APPS.INV_DIAG_RCV_PO dependencies on RCV_SHIPMENT_HEADERS

Line 104: l_org_id rcv_shipment_headers.organization_id%TYPE;

100: dummy_num NUMBER;
101: l_operating_id po_headers_all.org_id%TYPE;
102: l_po_number po_headers_all.segment1%TYPE;
103: l_line_num po_lines_all.line_num%TYPE;
104: l_org_id rcv_shipment_headers.organization_id%TYPE;
105: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
106: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
107:
108: BEGIN

Line 106: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

102: l_po_number po_headers_all.segment1%TYPE;
103: l_line_num po_lines_all.line_num%TYPE;
104: l_org_id rcv_shipment_headers.organization_id%TYPE;
105: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
106: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
107:
108: BEGIN
109: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
110: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

Line 166: rcv_shipment_headers rsh,

162: INTO l_count
163: FROM po_headers_all ph,
164: po_lines_all pl,
165: po_line_locations_all pll,
166: rcv_shipment_headers rsh,
167: rcv_shipment_lines rsl
168: WHERE rsh.shipment_header_id=rsl.shipment_header_id
169: AND rsl.po_header_id=ph.po_header_id
170: AND rsl.po_line_id=pl.po_line_id

Line 195: rcv_shipment_headers rsh,

191: IF l_operating_id IS NOT NULL AND l_po_number IS NOT NULL AND l_receipt_num IS NOT NULL AND l_org_id IS NOT NULL THEN
192: SELECT Count(1)
193: INTO l_count
194: FROM po_headers_all ph,
195: rcv_shipment_headers rsh,
196: rcv_shipment_lines rsl
197: WHERE rsh.shipment_header_id=rsl.shipment_header_id
198: AND rsl.po_header_id=ph.po_header_id
199: AND ph.segment1=l_po_number

Line 232: FROM rcv_shipment_headers rsh

228:
229: IF l_receipt_num IS NOT NULL AND l_org_id IS NOT NULL THEN
230: SELECT Count(1)
231: INTO l_count
232: FROM rcv_shipment_headers rsh
233: WHERE receipt_source_code='VENDOR'
234: AND rsh.receipt_num=l_receipt_num
235: AND rsh.ship_to_org_id=l_org_id;
236: IF l_count = 0 THEN

Line 304: RCV_SHIPMENT_HEADERS'||'

300: AP_INVOICE_LINES_INTERFACE'||'
301: AP_INVOICES_INTERFACE'||'
302: '||'
303: '||'
304: RCV_SHIPMENT_HEADERS'||'
305: RCV_SHIPMENT_LINES'||'
306: RCV_TRANSACTIONS'||'
307: '||'
308: '||'

Line 428: JTF_DIAGNOSTIC_COREAPI.insert_html('');

424:
425: sql_text:= po_sql(11);
426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details

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

425: sql_text:= po_sql(11);
426:
427: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Details