DBA Data[Home] [Help]

APPS.OE_BULK_LINE_UTIL dependencies on OE_CONFIG_DETAILS_TMP

Line 1037: , OE_CONFIG_DETAILS_TMP T

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

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

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

Line 1370: , OE_CONFIG_DETAILS_TMP T

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

Line 1718: , OE_CONFIG_DETAILS_TMP T

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

Line 2050: , OE_CONFIG_DETAILS_TMP T

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