APPS.FUN_XML_REPORT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 332: RA_CUSTOMER_TRX_ALL RCT,

328: HP.JGZZ_FISCAL_CODE AS CUST_TAXPAYER_ID,
329: HP.TAX_REFERENCE AS CUST_TAX_REGN_NUM
330: FROM FUN_NET_AR_TXNS_ALL FNAR,
331: FUN_NET_BATCHES_ALL FNB,
332: RA_CUSTOMER_TRX_ALL RCT,
333: RA_CUST_TRX_TYPES_ALL RCTT,
334: HZ_CUST_ACCOUNTS_ALL HCA,
335: HZ_PARTIES HP,
336: HZ_CUST_SITE_USES_ALL HCSU

Line 373: RA_CUSTOMER_TRX_ALL RCT,

369: MIN(APS.DUE_DATE) AS DUE_DATE,
370: sum(nvl(vat_amount,0)) AS VAT_AMOUNT -- Russian Requirement
371: FROM FUN_NET_AR_TXNS_ALL FNAR,
372: FUN_NET_BATCHES_ALL FNB,
373: RA_CUSTOMER_TRX_ALL RCT,
374: RA_CUST_TRX_TYPES_ALL RCTT,
375: AR_PAYMENT_SCHEDULES_ALL APS,
376: HZ_CUST_ACCOUNTS_ALL HCA,
377: HZ_PARTIES HP,

Line 384: ra_customer_trx_all rct2

380: (select
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

Line 685: RA_CUSTOMER_TRX_ALL RCT,

681: HP.JGZZ_FISCAL_CODE AS CUST_TAXPAYER_ID,
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,

Line 730: RA_CUSTOMER_TRX_ALL RCT,

726: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
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,

Line 743: ra_customer_trx_all rct2

739: (select
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