DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 354: RA_CUST_TRX_TYPES_ALL RCTT,

350: HP.TAX_REFERENCE AS CUST_TAX_REGN_NUM
351: FROM FUN_NET_AR_TXNS_ALL FNAR,
352: FUN_NET_BATCHES_ALL FNB,
353: RA_CUSTOMER_TRX_ALL RCT,
354: RA_CUST_TRX_TYPES_ALL RCTT,
355: HZ_CUST_ACCOUNTS_ALL HCA,
356: HZ_PARTIES HP,
357: HZ_CUST_SITE_USES_ALL HCSU
358: WHERE FNAR.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID

Line 399: RA_CUST_TRX_TYPES_ALL RCTT,

395: LTRIM(TO_CHAR(sum(nvl(vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT -- Russian Requirement
396: FROM FUN_NET_AR_TXNS_ALL FNAR,
397: FUN_NET_BATCHES_ALL FNB,
398: RA_CUSTOMER_TRX_ALL RCT,
399: RA_CUST_TRX_TYPES_ALL RCTT,
400: AR_PAYMENT_SCHEDULES_ALL APS,
401: HZ_CUST_ACCOUNTS_ALL HCA,
402: HZ_PARTIES HP,
403: HZ_CUST_SITE_USES_ALL HCSU,

Line 766: RA_CUST_TRX_TYPES_ALL RCTT,

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,
770: AR_CASH_RECEIPTS_ALL ACR,

Line 825: RA_CUST_TRX_TYPES_ALL RCTT,

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,
829: AR_CASH_RECEIPTS_ALL ACR,