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 367: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

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

Line 698: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

694: ,L.IB_owner_code
695: ,L.IB_current_location_code
696: ,L.IB_Installed_at_Location_code
697: , NULL -- fulfllment_base --ER#14763609
698: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
699: WHERE h.batch_id = p_batch_id
700: AND h.order_source_id = l.order_source_id
701: AND h.orig_sys_document_ref = l.orig_sys_document_ref
702: AND nvl(h.error_flag,'N') = 'N'

Line 1039: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

1035: , NULL tax_calculation_flag
1036: , NULL ato_line_index
1037: , NULL top_model_line_index
1038: , NULL fulfllment_base --fulfllment_base --ER#14763609
1039: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1040: , OE_CONFIG_DETAILS_TMP T
1041: WHERE h.batch_id = p_batch_id
1042: AND h.order_source_id = l.order_source_id
1043: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 1373: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

1369: , NULL tax_calculation_flag
1370: , NULL ato_line_index
1371: , NULL top_model_line_index
1372: , NULL fulfllment_base --fulfllment_base --ER#14763609
1373: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1374: , OE_CONFIG_DETAILS_TMP T
1375: WHERE h.batch_id = p_batch_id
1376: AND h.order_source_id = l.order_source_id
1377: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 1387: from OE_LINES_IFACE_ALL L1

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

Line 1722: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

1718: , NULL tax_calculation_flag
1719: , NULL ato_line_index
1720: , NULL top_model_line_index
1721: , NULL fulfllment_base --fulfllment_base --ER#14763609
1722: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1723: , OE_CONFIG_DETAILS_TMP T
1724: WHERE h.batch_id = p_batch_id
1725: AND h.order_source_id = l.order_source_id
1726: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 2055: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L

2051: , NULL tax_calculation_flag
2052: , NULL ato_line_index
2053: , NULL top_model_line_index
2054: , NULL fulfllment_base --fulfllment_base --ER#14763609
2055: FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
2056: , OE_CONFIG_DETAILS_TMP T
2057: WHERE h.batch_id = p_batch_id
2058: AND h.order_source_id = l.order_source_id
2059: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 2069: from OE_LINES_IFACE_ALL L1

2065: AND l.orig_sys_document_ref = t.orig_sys_document_ref
2066: AND l.top_model_line_ref = t.top_model_line_ref
2067: AND l.item_type_code = 'MODEL'
2068: AND NOT EXISTS ( select 1
2069: from OE_LINES_IFACE_ALL L1
2070: where l1.line_id = t.line_id)) LINES
2071: ORDER BY order_source_id,
2072: orig_sys_document_ref,
2073: decode(top_model_line_ref, NULL, orig_sys_line_ref, top_model_line_ref),