DBA Data[Home] [Help]

APPS.IGIRCABJP dependencies on AR_DISTRIBUTIONS

Line 88: ar_distributions_all ard,

84: 'AR_ADJUSTMENTS' ref30
85: FROM
86: ra_customer_trx_all ct,
87: ra_cust_trx_types_all ctt,
88: ar_distributions_all ard,
89: hz_parties, -- Bug 3902175
90: hz_cust_accounts, -- Bug 3902175
91: ar_adjustments_all adj,
92: ar_lookups l_cat,

Line 436: ar_distributions ard,

432: FROM
433: ar_lookups l_cat,
434: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
435: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
436: ar_distributions ard,
437: ar_cash_receipts cr,
438: ar_cash_receipt_history_all crh,
439: xla_ae_headers xah
440: WHERE crh.cash_receipt_history_id+0 < p_Report.NxtCashReceiptHistoryId

Line 589: ar_distributions ard,

585: 'AR_RECEIVABLE_APPLICATIONS' ref30
586: FROM
587: ar_receivable_applications ra,
588: ar_cash_receipts cr,
589: ar_distributions ard,
590: ra_customer_trx ctinv,
591: ar_lookups l_cat,
592: ar_posting_control pc,
593: ar_system_parameters sp,

Line 693: ar_distributions ard,

689: 'AR_RECEIVABLE_APPLICATIONS' ref30
690: FROM
691: ar_receivable_applications ra,
692: ra_customer_trx ctcm,
693: ar_distributions ard,
694: ra_cust_trx_line_gl_dist ctlgdcm,
695: ra_customer_trx ctinv,
696: ar_lookups l_cat,
697: ar_posting_control pc,

Line 842: ar_distributions ard,

838: 'MISC_' || ard.source_type ref29,
839: 'AR_MISC_CASH_DISTRIBUTIONS' ref30
840: FROM
841: ar_misc_cash_distributions mcd,
842: ar_distributions ard,
843: ar_cash_receipts cr,
844: ar_lookups l_cat,
845: xla_ae_headers xah
846: WHERE mcd.misc_cash_distribution_id+0 < p_Report.NxtMiscCashDistributionId