DBA Data[Home] [Help]

APPS.ARP_BALANCE_CHECK dependencies on AR_DISTRIBUTIONS

Line 213: ar_distributions ard

209: where cash_receipt_id = p_cr_id
210: and nvl(confirmed_flag,'Y') = 'Y'
211: and nvl(postable,'Y') = 'Y'
212: and posting_control_id = -3) src,
213: ar_distributions ard
214: where ard.source_id = src.src_id
215: and ard.source_table = src.src_tab
216: group by src.gl_date;
217:

Line 342: ar_distributions ard

338: from ar_adjustments
339: where adjustment_id = p_adj_id
340: and nvl(postable,'Y') = 'Y'
341: and posting_control_id = -3) src,
342: ar_distributions ard
343: where ard.source_id = src.src_id
344: and ard.source_table = src.src_tab;
345:
346: --------------------------------------------------------

Line 472: ar_distributions ard

468: from ar_receivable_applications
469: where receivable_application_id = p_receivable_application_id
470: and nvl(postable,'Y') = 'Y'
471: and posting_control_id = -3) src,
472: ar_distributions ard
473: where ard.source_id = src.src_id
474: and ard.source_table = src.src_tab;
475:
476: --------------------------------------------------------

Line 581: ar_distributions ard

577: where ( receivable_application_id = p_receivable_application_id1
578: or receivable_application_id = p_receivable_application_id2)
579: and nvl(postable,'Y') = 'Y'
580: and posting_control_id = -3) src,
581: ar_distributions ard
582: where ard.source_id = src.src_id
583: and ard.source_table = src.src_tab;
584:
585: --------------------------------------------------------