APPS.INV_DIAG_RCV_IPROC dependencies on RCV_SHIPMENT_HEADERS

Line 103: l_org_id rcv_shipment_headers.organization_id%TYPE;

99: dummy_num NUMBER;
100: l_operating_id po_headers_all.org_id%TYPE;
101: l_req_number po_headers_all.segment1%TYPE;
102: l_line_num po_lines_all.line_num%TYPE;
103: l_org_id rcv_shipment_headers.organization_id%TYPE;
104: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
105:
106: BEGIN
107: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

Line 104: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

100: l_operating_id po_headers_all.org_id%TYPE;
101: l_req_number po_headers_all.segment1%TYPE;
102: l_line_num po_lines_all.line_num%TYPE;
103: l_org_id rcv_shipment_headers.organization_id%TYPE;
104: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
105:
106: BEGIN
107: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
108: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

Line 163: rcv_shipment_headers rsh,

159: SELECT Count(1)
160: INTO l_count
161: FROM po_requisition_headers_all prh,
162: po_requisition_lines_all prl,
163: rcv_shipment_headers rsh,
164: rcv_shipment_lines rsl,
165: po_line_locations_all pll ,
166: po_distributions_all pd,
167: po_req_distributions_all prd

Line 215: FROM rcv_shipment_headers rsh

211: IF l_receipt_num IS NOT NULL AND l_org_id IS NOT NULL THEN
212:
213: SELECT Count(1)
214: INTO l_count
215: FROM rcv_shipment_headers rsh
216: WHERE receipt_source_code='VENDOR'
217: AND rsh.receipt_num=l_receipt_num
218: AND rsh.ship_to_org_id=l_org_id;
219: IF l_count = 0 THEN

Line 291: RCV_SHIPMENT_HEADERS'||'

287: AP_INVOICES_INTERFACE'||'
288: '||'
289: '||'
290: AP_INVOICE_LINES_INTERFACE'||'
291: RCV_SHIPMENT_HEADERS'||'
292: RCV_SHIPMENT_LINES'||'
293: '||'
294: '||'
295: RCV_TRANSACTIONS'||'

Line 438: JTF_DIAGNOSTIC_COREAPI.insert_html('');

434:
435: sql_text:= po_sql(14);
436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

Line 439: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS  [Top]');

435: sql_text:= po_sql(14);
436:
437: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details