R12_AR_Invoice_Data

/* Formatted on 17-08-2011 22:20:14 (QP5 v5.115.810.9015) */
SELECT   hou.name Operating_unit,
         typ.NAME Transaction_Type,
         rcta.CUSTOMER_TRX_ID,
         TRX_NUMBER,
         TRX_DATE,
         line.EXTENDED_AMOUNT
  FROM   ra_customer_trx_all rcta,
         ra_customer_trx_lines_all line,
         hr_operating_units hou,
         RA_CUST_TRX_TYPES_ALL typ,
         ra_cust_trx_line_gl_dist_all dist
 WHERE       RCTA.CUSTOMER_TRX_ID = line.CUSTOMER_TRX_ID
         AND hou.organization_id = rcta.org_id
         AND typ.CUST_TRX_TYPE_ID = rcta.CUST_TRX_TYPE_ID
         and rcta.CUSTOMER_TRX_ID=dist.CUSTOMER_TRX_ID
         and dist.CUSTOMER_TRX_LINE_ID=line.CUSTOMER_TRX_LINE_ID
         and trunc(GL_DATE) <= '31-MAR-2011'
         --AND RCTA.CUSTOMER_TRX_ID = 1000