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.

APPS.OE_BULK_LINE_UTIL dependencies on OE_LINES_IFACE_ALL

Line 366: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

362: , NULL -- cust_trx_type_id
363: , NULL -- tax_calculation_flag
364: , NULL -- ato_line_index
365: , NULL -- top_model_line_index
366: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
367: WHERE h.batch_id = p_batch_id
368: AND h.order_source_id = l.order_source_id
369: AND h.orig_sys_document_ref = l.orig_sys_document_ref
370: AND nvl(h.error_flag,'N') = 'N'

Line 696: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

692: ,L.End_customer_site_use_id
693: ,L.IB_owner_code
694: ,L.IB_current_location_code
695: ,L.IB_Installed_at_Location_code
696: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
697: WHERE h.batch_id = p_batch_id
698: AND h.order_source_id = l.order_source_id
699: AND h.orig_sys_document_ref = l.orig_sys_document_ref
700: AND nvl(h.error_flag,'N') = 'N'

Line 1036: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

1032: , NULL cust_trx_type_id
1033: , NULL tax_calculation_flag
1034: , NULL ato_line_index
1035: , NULL top_model_line_index
1036: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1037: , OE_CONFIG_DETAILS_TMP T
1038: WHERE h.batch_id = p_batch_id
1039: AND h.order_source_id = l.order_source_id
1040: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 1369: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

1365: , NULL cust_trx_type_id
1366: , NULL tax_calculation_flag
1367: , NULL ato_line_index
1368: , NULL top_model_line_index
1369: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1370: , OE_CONFIG_DETAILS_TMP T
1371: WHERE h.batch_id = p_batch_id
1372: AND h.order_source_id = l.order_source_id
1373: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 1383: from OE_LINES_IFACE_ALL L1

1379: AND l.orig_sys_document_ref = t.orig_sys_document_ref
1380: AND l.top_model_line_ref = t.top_model_line_ref
1381: AND l.item_type_code = 'MODEL'
1382: AND NOT EXISTS ( select 1
1383: from OE_LINES_IFACE_ALL L1
1384: where l1.line_id = t.line_id) ) LINES
1385: ORDER BY order_source_id,
1386: orig_sys_document_ref,
1387: decode(top_model_line_ref, null, orig_sys_line_ref, top_model_line_ref),

Line 1717: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

1713: , NULL cust_trx_type_id
1714: , NULL tax_calculation_flag
1715: , NULL ato_line_index
1716: , NULL top_model_line_index
1717: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1718: , OE_CONFIG_DETAILS_TMP T
1719: WHERE h.batch_id = p_batch_id
1720: AND h.order_source_id = l.order_source_id
1721: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 2049: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

2045: , NULL cust_trx_type_id
2046: , NULL tax_calculation_flag
2047: , NULL ato_line_index
2048: , NULL top_model_line_index
2049: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
2050: , OE_CONFIG_DETAILS_TMP T
2051: WHERE h.batch_id = p_batch_id
2052: AND h.order_source_id = l.order_source_id
2053: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 2063: from OE_LINES_IFACE_ALL L1

2059: AND l.orig_sys_document_ref = t.orig_sys_document_ref
2060: AND l.top_model_line_ref = t.top_model_line_ref
2061: AND l.item_type_code = 'MODEL'
2062: AND NOT EXISTS ( select 1
2063: from OE_LINES_IFACE_ALL L1
2064: where l1.line_id = t.line_id)) LINES
2065: ORDER BY order_source_id,
2066: orig_sys_document_ref,
2067: decode(top_model_line_ref, NULL, orig_sys_line_ref, top_model_line_ref),