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 385: ,ra_customer_trx_lines_all rctl2

381: rctl2.customer_trx_id
382: ,sum(rctl2.extended_amount) AS VAT_AMOUNT
383: from
384: ra_customer_trx_all rct2
385: ,ra_customer_trx_lines_all rctl2
386: ,ar_vat_tax_all_b avt
387: where
388: rct2.bill_to_customer_id=:CUST_ACCOUNT_ID
389: and rct2.bill_to_site_use_id=:SITE_USE_ID

Line 686: RA_CUSTOMER_TRX_LINES_ALL RCTL,

682: HP.TAX_REFERENCE AS CUST_TAX_REGN_NUM
683: FROM FUN_NET_AR_TXNS_ALL FNAR,
684: FUN_NET_BATCHES_ALL FNB,
685: RA_CUSTOMER_TRX_ALL RCT,
686: RA_CUSTOMER_TRX_LINES_ALL RCTL,
687: RA_CUST_TRX_TYPES_ALL RCTT,
688: HZ_CUST_ACCOUNTS_ALL HCA,
689: HZ_PARTIES HP,
690: HZ_CUST_SITE_USES_ALL HCSU,

Line 731: RA_CUSTOMER_TRX_LINES_ALL RCTL,

727: ACR.RECEIPT_NUMBER,
728: sum(nvl(vat_amount,0)) AS VAT_AMOUNT -- Russian Requirement
729: FROM FUN_NET_AR_TXNS_ALL FNAR,
730: RA_CUSTOMER_TRX_ALL RCT,
731: RA_CUSTOMER_TRX_LINES_ALL RCTL,
732: RA_CUST_TRX_TYPES_ALL RCTT,
733: HZ_CUST_ACCOUNTS_ALL HCA,
734: HZ_PARTIES HP,
735: HZ_CUST_SITE_USES_ALL HCSU,

Line 744: ,ra_customer_trx_lines_all rctl2

740: rctl2.customer_trx_id
741: ,sum(rctl2.extended_amount) AS VAT_AMOUNT
742: from
743: ra_customer_trx_all rct2
744: ,ra_customer_trx_lines_all rctl2
745: ,ar_vat_tax_all_b avt
746: where
747: rct2.bill_to_customer_id=:CUST_ACCOUNT_ID
748: and rct2.bill_to_site_use_id=:SITE_USE_ID