DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 336: HZ_CUST_SITE_USES_ALL HCSU

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
337: WHERE FNAR.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
338: AND FNAR.BATCH_ID = FNB.BATCH_ID
339: AND RCTT.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
340: AND RCT.ORG_ID = RCTT.ORG_ID

Line 378: HZ_CUST_SITE_USES_ALL HCSU,

374: RA_CUST_TRX_TYPES_ALL RCTT,
375: AR_PAYMENT_SCHEDULES_ALL APS,
376: HZ_CUST_ACCOUNTS_ALL HCA,
377: HZ_PARTIES HP,
378: HZ_CUST_SITE_USES_ALL HCSU,
379: -- Russian Requirement
380: (select
381: rctl2.customer_trx_id
382: ,sum(rctl2.extended_amount) AS VAT_AMOUNT

Line 690: HZ_CUST_SITE_USES_ALL HCSU,

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,
691: AR_CASH_RECEIPTS_ALL ACR
692: WHERE FNAR.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
693: AND RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID
694: AND RCTT.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID

Line 735: HZ_CUST_SITE_USES_ALL HCSU,

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,
736: AR_CASH_RECEIPTS_ALL ACR,
737: FUN_NET_BATCHES_ALL FNB,
738: -- Russian Requirement
739: (select