AR_LINE

/* Formatted on 09-08-2011 16:25:39 (QP5 v5.115.810.9015) */
SELECT   DISTINCT (SELECT   name
                     FROM   hr_operating_units
                    WHERE   organization_id = rctl.org_id)
                     Operating_unit,
                  RCTA.TRX_NUMBER,
                  rctl.customer_trx_id L_LINE_HEADER_ID,
                  rctl.line_number L_LINE_NUM,
                  rctl.description L_DESCRIPTION,
                  rctl.QUANTITY_INVOICED L_QUANTITY,
                  rctl.unit_selling_price L_UNIT_PRICE,
                  RCTL.EXTENDED_AMOUNT Txn_Amount,
                  rctl.attribute_category L_ATTR_CONTEXT,
                  rctl.attribute1 L_ATTRIBUTE1,
                  rctl.attribute2 L_ATTRIBUTE2,
                  rctl.attribute3 L_ATTRIBUTE3,
                  rctl.attribute4 L_ATTRIBUTE4,
                  rctl.attribute5 L_ATTRIBUTE5,
                  rctl.memo_line_id L_MEMO_LINE
  FROM   ra_customer_trx_lines_all rctl,
         ra_cust_trx_line_gl_dist_all rct,
         ra_customer_trx_all rcta
 WHERE       rctl.customer_trx_line_id = rct.customer_trx_line_id
         AND rctl.customer_trx_id = rcta.customer_trx_id
         AND rcta.customer_trx_id = rct.customer_trx_id
         --AND rcta.customer_trx_id = jai.customer_trx_id(+)
         --AND jai.customer_trx_id = jline.customer_trx_id
         AND rcta.org_id = rctl.org_id
         AND rctl.LINE_TYPE = 'LINE'
         AND TRUNC (rcta.TRX_DATE) BETWEEN '01-AUG-2011' AND '13-AUG-2011'
         AND rcta.SET_OF_BOOKS_ID = 5