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_HEADERS_IFACE_ALL

Line 46: SELECT /+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) /

42: )
43: IS
44:
45: CURSOR c_lines IS
46: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
47: L.ACCOUNTING_RULE_ID
48: , L.ACCOUNTING_RULE_DURATION
49: , L.ACTUAL_ARRIVAL_DATE
50: -- , L.ACTUAL_SHIPMENT_DATE

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 381: SELECT /+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) /

377: , l.orig_sys_line_ref
378: ,l.orig_sys_shipment_ref;
379:
380: CURSOR c_lines_rtrim IS
381: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
382: L.ACCOUNTING_RULE_ID
383: , L.ACCOUNTING_RULE_DURATION
384: , L.ACTUAL_ARRIVAL_DATE
385: -- , L.ACTUAL_SHIPMENT_DATE

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 717: SELECT /+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) /

713: ----------------
714: CURSOR c_lines1 IS
715: SELECT * FROM (
716: -- records from the line interface tables ( include standard items and config items)
717: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
718: L.ACCOUNTING_RULE_ID
719: , L.ACCOUNTING_RULE_DURATION
720: , L.ACTUAL_ARRIVAL_DATE
721: -- , L.ACTUAL_SHIPMENT_DATE

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 1051: SELECT /+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) /

1047: AND nvl(l.rejected_flag,'N') = 'N'
1048: AND l.line_id = t.line_id(+)
1049: UNION ALL
1050: -- records from oe_config_details_tmp and not in line interface table
1051: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1052: NULL ACCOUNTING_RULE_ID
1053: , NULL ACCOUNTING_RULE_DURATION
1054: , NULL ACTUAL_ARRIVAL_DATE
1055: -- , L.ACTUAL_SHIPMENT_DATE

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 1402: SELECT /+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) /

1398: ----------------
1399:
1400: CURSOR c_lines1_rtrim IS
1401: SELECT * FROM (
1402: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1403: L.ACCOUNTING_RULE_ID
1404: , L.ACCOUNTING_RULE_DURATION
1405: , L.ACTUAL_ARRIVAL_DATE
1406: , L.AGREEMENT_ID

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 1733: SELECT /+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) /

1729: AND nvl(l.error_flag,'N') = 'N'
1730: AND nvl(l.rejected_flag,'N') = 'N'
1731: AND l.line_id = t.line_id(+)
1732: UNION ALL
1733: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1734: NULL ACCOUNTING_RULE_ID
1735: , NULL ACCOUNTING_RULE_DURATION
1736: , NULL ACTUAL_ARRIVAL_DATE
1737: -- , NULL ACTUAL_SHIPMENT_DATE

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

APPS.OE_BULK_LINE_UTIL dependencies on OE_HEADERS_IFACE_ALL

Line 46: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */