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 826: rcv_shipment_headers rsh,

822: p_org_id,
823: p_po_uom
824: FROM
825: rcv_transactions rtxn,
826: rcv_shipment_headers rsh,
827: rcv_shipment_lines rsl,
828: po_headers ph,
829: po_line_locations pll,
830: po_lines pl,

Line 1000: rcv_shipment_headers rsh,

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