DBA Data[Home] [Help]

APPS.RCV_VALIDATE_PO dependencies on RCV_SHIPMENT_HEADERS

Line 192: rcv_shipment_headers rsh

188: SELECT rsh.shipment_header_id,
189: rsh.receipt_num,
190: Min(rt.transaction_date)
191: FROM rcv_transactions rt,
192: rcv_shipment_headers rsh
193: WHERE rt.shipment_header_id = rsh.shipment_header_id
194: AND rt.po_header_id = p_po_header_id
195: AND rt.source_document_code = 'PO'
196: AND rt.transaction_type IN ('RECEIVE', 'MATCH')

Line 203: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

199: rsh.receipt_num;
200:
201:
202: l_po_header_id po_headers_all.po_header_id%TYPE;
203: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
204: l_receipt_date rcv_transactions.transaction_date%TYPE;
205: l_receipt_number rcv_shipment_headers.receipt_num%TYPE;
206: l_multi_mod_val_result_id NUMBER;
207: l_receipt_amount NUMBER;

Line 205: l_receipt_number rcv_shipment_headers.receipt_num%TYPE;

201:
202: l_po_header_id po_headers_all.po_header_id%TYPE;
203: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
204: l_receipt_date rcv_transactions.transaction_date%TYPE;
205: l_receipt_number rcv_shipment_headers.receipt_num%TYPE;
206: l_multi_mod_val_result_id NUMBER;
207: l_receipt_amount NUMBER;
208: l_exception_type VARCHAR2(200) := NULL ;
209: l_message_name VARCHAR2(200) := NULL;

Line 240: FROM rcv_shipment_headers rsh,

236:
237: l_progress := '030';
238: SELECT rsh.receipt_num, Min(rt.transaction_date)
239: INTO l_receipt_number, l_receipt_date
240: FROM rcv_shipment_headers rsh,
241: rcv_transactions rt
242: WHERE rt.shipment_header_id = rsh.shipment_header_id
243: AND rt.transaction_type IN ('RECEIVE', 'MATCH')
244: AND rsh.shipment_header_id = l_shipment_header_id