DBA Data[Home] [Help]

APPS.OE_BULK_LINE_UTIL dependencies on OE_CONFIG_DETAILS_TMP

Line 1040: , OE_CONFIG_DETAILS_TMP T

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
1044: AND nvl(h.error_flag,'N') = 'N'

Line 1050: -- records from oe_config_details_tmp and not in line interface table

1046: AND nvl(l.error_flag,'N') = 'N'
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

Line 1374: , OE_CONFIG_DETAILS_TMP T

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
1378: AND nvl(h.error_flag,'N') = 'N'

Line 1723: , OE_CONFIG_DETAILS_TMP T

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
1727: AND nvl(h.error_flag,'N') = 'N'

Line 2056: , OE_CONFIG_DETAILS_TMP T

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
2060: AND nvl(h.error_flag,'N') = 'N'