APPS.INV_DIAG_RCV_RMA dependencies on RCV_SHIPMENT_HEADERS

Line 108: l_org_id rcv_shipment_headers.organization_id%TYPE;

104: dummy_num NUMBER;
105: l_operating_id po_headers_all.org_id%TYPE;
106: l_rma_number po_headers_all.segment1%TYPE;
107: l_line_num po_lines_all.line_num%TYPE;
108: l_org_id rcv_shipment_headers.organization_id%TYPE;
109: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
110: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
111: BEGIN
112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

Line 110: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

106: l_rma_number po_headers_all.segment1%TYPE;
107: l_line_num po_lines_all.line_num%TYPE;
108: l_org_id rcv_shipment_headers.organization_id%TYPE;
109: l_line_loc_num po_line_locations_all.shipment_num%TYPE;
110: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
111: BEGIN
112: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
113: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
114: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line 192: from rcv_shipment_headers

188: if l_receipt_num is not null and l_org_id is not null then
189: begin
190: select shipment_header_id
191: into l_rma_count
192: from rcv_shipment_headers
193: where receipt_num = l_receipt_num
194: and ship_to_org_id = l_org_id;
195: EXCEPTION
196: WHEN No_Data_Found THEN

Line 252: RCV_SHIPMENT_HEADERS'||'

248: OE_ORDER_LINES_ALL'||'
249: MTL_SYSTEM_ITEMS'||'
250: '||'
251: '||'
252: RCV_SHIPMENT_HEADERS'||'
253: RCV_SHIPMENT_LINES'||'
254: RCV_TRANSACTIONS'||'
255: '||'
256: '||'

Line 330: JTF_DIAGNOSTIC_COREAPI.insert_html('');

326:
327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information

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

327: JTF_DIAGNOSTIC_COREAPI.insert_html('

Receipt Information