APPS.INV_DIAG_RCV_IO dependencies on RCV_SHIPMENT_HEADERS

Line 102: l_org_id rcv_shipment_headers.organization_id%TYPE;

98: dummy_num NUMBER;
99: l_req_num po_requisition_headers_all.segment1%TYPE;
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;

Line 103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

99: l_req_num po_requisition_headers_all.segment1%TYPE;
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;
107:

Line 104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;

100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;
107:
108: BEGIN

Line 135: from rcv_shipment_headers rsh

131: begin
132:
133: select shipment_num
134: into l_shipment_num
135: from rcv_shipment_headers rsh
136: where receipt_num = l_receipt_num
137: and ship_to_org_id = l_org_id
138: and rsh.receipt_source_code = 'INTERNAL ORDER';
139:

Line 152: from rcv_shipment_headers rsh

148:
149: begin
150: select receipt_num
151: into l_receipt_num
152: from rcv_shipment_headers rsh
153: where shipment_num = l_shipment_num
154: and ship_to_org_id = l_org_id
155: and rsh.receipt_source_code = 'INTERNAL ORDER';
156:

Line 243: rcv_shipment_headers rsh,

239: SELECT Count(*)
240: INTO l_count
241: FROM po_requisition_headers_all prh,
242: po_requisition_lines_all prl,
243: rcv_shipment_headers rsh,
244: rcv_shipment_lines rsl
245: WHERE prh.segment1 = l_req_num
246: AND prh.org_id = l_ou_id
247: AND prh.requisition_header_id = prl.requisition_header_id

Line 272: rcv_shipment_headers rsh,

268: SELECT Count(*)
269: INTO l_count
270: FROM po_requisition_headers_all prh,
271: po_requisition_lines_all prl,
272: rcv_shipment_headers rsh,
273: rcv_shipment_lines rsl
274: WHERE prh.segment1 = l_req_num
275: AND prh.org_id = l_ou_id
276: AND prh.requisition_header_id = prl.requisition_header_id

Line 317: FROM rcv_shipment_headers rsh,

313: IF (l_receipt_num is NOT NULL AND l_shipment_num is NOT NULL AND l_org_id is NOT NULL ) THEN
314:
315: SELECT Count(*)
316: INTO l_count
317: FROM rcv_shipment_headers rsh,
318: rcv_shipment_lines rsl
319: WHERE rsh.shipment_num = l_shipment_num
320: AND rsh.receipt_num = l_receipt_num
321: AND rsh.ship_to_org_id = l_org_id

Line 357: FROM rcv_shipment_headers rsh,

353: IF (l_receipt_num is NOT NULL AND l_org_id is NOT NULL) THEN
354:
355: SELECT Count(*)
356: INTO l_count
357: FROM rcv_shipment_headers rsh,
358: rcv_shipment_lines rsl
359: WHERE rsh.receipt_num = l_receipt_num
360: AND rsh.ship_to_org_id = l_org_id
361: AND rsh.receipt_source_code = 'INTERNAL ORDER';

Line 376: FROM rcv_shipment_headers rsh,

372: IF (l_shipment_num is NOT NULL AND l_org_id is NOT NULL ) THEN
373:
374: SELECT Count(*)
375: INTO l_count
376: FROM rcv_shipment_headers rsh,
377: rcv_shipment_lines rsl
378: WHERE rsh.shipment_num = l_shipment_num
379: AND rsh.ship_to_org_id = l_org_id
380: AND rsh.receipt_source_code = 'INTERNAL ORDER';

Line 469: RCV_SHIPMENT_HEADERS'||'

465: '||'
466: '||'
467: OE_ORDER_LINES'||'
468: WSH_DELIVERY_DETAILS'||'
469: RCV_SHIPMENT_HEADERS'||'
470: '||'
471: '||'
472: RCV_SHIPMENT_LINES'||'
473: RCV_TRANSACTIONS'||'

Line 565: JTF_DIAGNOSTIC_COREAPI.insert_html('');

561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

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

562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details