[Home] [Help]
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,
93: xla_ae_headers xah
94: WHERE
95: adj.adjustment_id +0 < p_Report.NxtAdjustmentId
96: and adj.set_of_books_id = p_Report.SetOfBooksId
253: 'CB', 'CB_',
254: 'INV_')||ctlgd.account_class ref29,
255: 'RA_CUST_TRX_LINE_GL_DIST' ref30
256: FROM
257: ar_lookups l_cat,
258: ra_cust_trx_types ctt,
259: hz_parties, -- Bug 3902175
260: hz_cust_accounts, -- Bug 3902175
261: ra_customer_trx_all ct,
429: 'MISC', 'MISC_',
430: 'TRADE_')||ard.source_type ref29,
431: 'AR_CASH_RECEIPT_HISTORY' ref30
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,
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,
594: gl_sets_of_books gl,
595: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
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,
698: ar_system_parameters sp,
699: gl_sets_of_books gl,
700: hz_parties,
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
847: and mcd.set_of_books_id = p_Report.SetOfBooksId
848: and mcd.cash_receipt_id = cr.cash_receipt_id