APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 325: From ap_invoice_distributions aid,

321:
322: Begin
323: Select 'Y'
324: Into l_invoice_exists
325: From ap_invoice_distributions aid,
326: po_distributions pd,
327: po_line_locations pll
328: where aid.po_distribution_id = pd.po_distribution_id
329: and pd.line_location_id = pll.line_location_id

Line 346: FROM ap_invoice_distributions aid

342: BEGIN
343:
344: SELECT 'Y'
345: INTO l_invoice_exists
346: FROM ap_invoice_distributions aid
347: WHERE aid.po_distribution_id = p_po_dist_id
348: AND nvl(aid.rcv_transaction_id,-1) =
349: nvl(DECODE(l_match_option,'P',NULL,p_rcv_txn_id),-1)
350: AND rownum = 1;

Line 1071: FROM ap_invoice_distributions aid,

1067: BEGIN
1068:
1069: SELECT 'Y'
1070: INTO l_invoice_exists
1071: FROM ap_invoice_distributions aid,
1072: rcv_shipment_headers rsh,
1073: rcv_transactions rct,
1074: po_distributions pod
1075: WHERE aid.po_distribution_id = pod.po_distribution_id