APPS.INV_DIAG_RCV_PO dependencies on PO_HEADERS_ALL

Line 101: l_operating_id po_headers_all.org_id%TYPE;

97: po_sql INV_DIAG_RCV_PO_COMMON.sqls_list; -- Table of varchar2
98: l_skip_rest VARCHAR2(1):= 'N'; -- Flag for skipping a Data collection Package call.
99:
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;

Line 102: l_po_number po_headers_all.segment1%TYPE;

98: l_skip_rest VARCHAR2(1):= 'N'; -- Flag for skipping a Data collection Package call.
99:
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;

Line 163: FROM po_headers_all ph,

159: 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
160: AND (l_line_num IS NOT NULL OR l_line_loc_num IS NOT NULL) THEN
161: SELECT Count(1)
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

Line 194: FROM po_headers_all ph,

190:
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

Line 216: FROM po_headers_all ph

212:
213: IF l_operating_id IS NOT NULL AND l_po_number IS NOT NULL THEN
214: SELECT Count(1)
215: INTO l_count
216: FROM po_headers_all ph
217: where ph.segment1=l_po_number
218: AND ph.org_id=l_operating_id;
219: IF l_count = 0 THEN
220: statusStr := 'FAILURE';

Line 289: PO_HEADERS_ALL'||'

285: '||'
286: INDEX OF QUERIES'||'
287: '||'
288: '||'
289: PO_HEADERS_ALL'||'
290: PO_LINES_ALL'||'
291: PO_LINE_LOCATIONS_ALL'||'
292: '||'
293: '||'

Line 365: JTF_DIAGNOSTIC_COREAPI.insert_html('');

361: -- Execute the Sqls
362: -------------------
363: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

Line 366: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');

362: -------------------
363: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details