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 OE_ORDER_HEADERS_ALL
Line 173: from oe_order_headers_all
169: if l_rma_number is not null and l_operating_id is not null then
170: begin
171: select header_id
172: into l_rma_count
173: from oe_order_headers_all
174: where org_id = l_operating_id
175: and order_number = l_rma_number;
176: EXCEPTION
177: WHEN No_Data_Found THEN
243:
'||'
244: INDEX OF QUERIES '||'
245: '||'
246: '||'
247: OE_ORDER_HEADERS_ALL '||'
248: OE_ORDER_LINES_ALL '||'
249: MTL_SYSTEM_ITEMS '||'
250: '||'
251: '||'
Line 309: JTF_DIAGNOSTIC_COREAPI.insert_html(' ');
305:
306: JTF_DIAGNOSTIC_COREAPI.insert_html('
RMA Information ');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html(' ');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top] ');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
Line 310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top] ');
306: JTF_DIAGNOSTIC_COREAPI.insert_html('
RMA Information ');
307:
308: sql_text := rma1_sql(1);
309: JTF_DIAGNOSTIC_COREAPI.insert_html(' ');
310: JTF_DIAGNOSTIC_COREAPI.insert_html('OE_ORDER_HEADERS_ALL [Top] ');
311: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
312: JTF_DIAGNOSTIC_COREAPI.BRPrint;
313:
314: sql_text := rma1_sql(2);