APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 318: From ap_invoice_distributions aid,

314:
315: Begin
316: Select 'Y'
317: Into l_invoice_exists
318: From ap_invoice_distributions aid,
319: po_distributions pd,
320: po_line_locations pll
321: where aid.po_distribution_id = pd.po_distribution_id
322: and pd.line_location_id = pll.line_location_id

Line 339: FROM ap_invoice_distributions aid

335: BEGIN
336:
337: SELECT 'Y'
338: INTO l_invoice_exists
339: FROM ap_invoice_distributions aid
340: WHERE aid.po_distribution_id = p_po_dist_id
341: AND nvl(aid.rcv_transaction_id,-1) =
342: nvl(DECODE(l_match_option,'P',NULL,p_rcv_txn_id),-1)
343: AND rownum = 1;

Line 999: FROM ap_invoice_distributions aid,

995: BEGIN
996:
997: SELECT 'Y'
998: INTO l_invoice_exists
999: FROM ap_invoice_distributions aid,
1000: rcv_shipment_headers rsh,
1001: rcv_transactions rct,
1002: po_distributions pod
1003: WHERE aid.po_distribution_id = pod.po_distribution_id