APPS.ARP_BALANCE_CHECK dependencies on AR_DISTRIBUTIONS

Line 225: ar_distributions ard

221: where cash_receipt_id = p_cr_id
222: and nvl(confirmed_flag,'Y') = 'Y'
223: and nvl(postable,'Y') = 'Y'
224: and posting_control_id = -3) src,
225: ar_distributions ard
226: where ard.source_id = src.src_id
227: and ard.source_table = src.src_tab
228: group by src.gl_date;
229:

Line 462: ar_distributions ard

458: and cr.cash_receipt_id = ra.cash_receipt_id
459: and nvl(ra.confirmed_flag,'Y') = 'Y'
460: and nvl(ra.postable,'Y') = 'Y'
461: and ra.posting_control_id = -3) src,
462: ar_distributions ard
463: where ard.source_id = src.src_id
464: and ard.source_table = src.src_tab
465: group by src.gl_date, src.cr_id
466: having ((sum(nvl(amount_dr,0)) <> sum(nvl(amount_cr,0)) AND max(src.cc_flag) = 'N')

Line 588: ar_distributions ard

584: from ar_adjustments
585: where adjustment_id = p_adj_id
586: and nvl(postable,'Y') = 'Y'
587: and posting_control_id = -3) src,
588: ar_distributions ard
589: where ard.source_id = src.src_id
590: and ard.source_table = src.src_tab;
591:
592: --------------------------------------------------------

Line 784: ar_distributions ard

780: from ar_receivable_applications
781: where receivable_application_id = p_receivable_application_id
782: and nvl(postable,'Y') = 'Y'
783: and posting_control_id = -3) src,
784: ar_distributions ard
785: where ard.source_id = src.src_id
786: and ard.source_table = src.src_tab;
787:
788: --------------------------------------------------------

Line 975: ar_distributions ard

971: where ( receivable_application_id = p_receivable_application_id1
972: or receivable_application_id = p_receivable_application_id2)
973: and nvl(postable,'Y') = 'Y'
974: and posting_control_id = -3) src,
975: ar_distributions ard
976: where ard.source_id = src.src_id
977: and ard.source_table = src.src_tab;
978:
979: --------------------------------------------------------