eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_XML_REPORT_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 410: ,ra_customer_trx_lines_all rctl2

406: rctl2.customer_trx_id
407: ,sum(rctl2.extended_amount) AS VAT_AMOUNT
408: from
409: ra_customer_trx_all rct2
410: ,ra_customer_trx_lines_all rctl2
411: ,ar_vat_tax_all_b avt
412: where
413: rct2.bill_to_customer_id=:CUST_ACCOUNT_ID
414: and rct2.bill_to_site_use_id=:SITE_USE_ID

Line 765: RA_CUSTOMER_TRX_LINES_ALL RCTL,

761: HZL.POSTAL_CODE AS CUSTOMER_POSTAL_CODE
762: FROM FUN_NET_AR_TXNS_ALL FNAR,
763: FUN_NET_BATCHES_ALL FNB,
764: RA_CUSTOMER_TRX_ALL RCT,
765: RA_CUSTOMER_TRX_LINES_ALL RCTL,
766: RA_CUST_TRX_TYPES_ALL RCTT,
767: HZ_CUST_ACCOUNTS_ALL HCA,
768: HZ_PARTIES HP,
769: HZ_CUST_SITE_USES_ALL HCSU,

Line 824: RA_CUSTOMER_TRX_LINES_ALL RCTL,

820: ACR.RECEIPT_NUMBER,
821: LTRIM(TO_CHAR(sum(nvl(vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT -- Russian Requirement
822: FROM FUN_NET_AR_TXNS_ALL FNAR,
823: RA_CUSTOMER_TRX_ALL RCT,
824: RA_CUSTOMER_TRX_LINES_ALL RCTL,
825: RA_CUST_TRX_TYPES_ALL RCTT,
826: HZ_CUST_ACCOUNTS_ALL HCA,
827: HZ_PARTIES HP,
828: HZ_CUST_SITE_USES_ALL HCSU,

Line 837: ,ra_customer_trx_lines_all rctl2

833: rctl2.customer_trx_id
834: ,sum(rctl2.extended_amount) AS VAT_AMOUNT
835: from
836: ra_customer_trx_all rct2
837: ,ra_customer_trx_lines_all rctl2
838: ,ar_vat_tax_all_b avt
839: where
840: rct2.bill_to_customer_id=:CUST_ACCOUNT_ID
841: and rct2.bill_to_site_use_id=:SITE_USE_ID