APPS.AP_AUTO_DM_CREATION_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

184: l_rcv_txn_date rcv_transactions.transaction_date%TYPE;
185: l_rcv_rate rcv_transactions.currency_conversion_rate%TYPE;
186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

Line 897: rcv_shipment_headers rsh,

893: p_org_id,
894: p_po_uom
895: FROM
896: rcv_transactions rtxn,
897: rcv_shipment_headers rsh,
898: rcv_shipment_lines rsl,
899: po_headers ph,
900: po_line_locations pll,
901: po_lines pl,

Line 1072: rcv_shipment_headers rsh,

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
1076: AND pod.line_location_id = rct.po_line_location_id