eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
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
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 ');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html(' ');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top] ');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
Line 331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top] ');
327: JTF_DIAGNOSTIC_COREAPI.insert_html('
Receipt Information ');
328:
329: sql_text := rma1_sql(4);
330: JTF_DIAGNOSTIC_COREAPI.insert_html(' ');
331: JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top] ');
332: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
333: JTF_DIAGNOSTIC_COREAPI.BRPrint;
334:
335: sql_text := rma1_sql(5);