[Home] [Help]
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
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'
376: , l.orig_sys_line_ref
377: ,l.orig_sys_shipment_ref;
378:
379: CURSOR c_lines_rtrim IS
380: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
381: L.ACCOUNTING_RULE_ID
382: , L.ACCOUNTING_RULE_DURATION
383: , L.ACTUAL_ARRIVAL_DATE
384: -- , L.ACTUAL_SHIPMENT_DATE
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'
711: ----------------
712: CURSOR c_lines1 IS
713: SELECT * FROM (
714: -- records from the line interface tables ( include standard items and config items)
715: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
716: L.ACCOUNTING_RULE_ID
717: , L.ACCOUNTING_RULE_DURATION
718: , L.ACTUAL_ARRIVAL_DATE
719: -- , L.ACTUAL_SHIPMENT_DATE
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
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
1052: -- , L.ACTUAL_SHIPMENT_DATE
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
1394: ----------------
1395:
1396: CURSOR c_lines1_rtrim IS
1397: SELECT * FROM (
1398: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1399: L.ACCOUNTING_RULE_ID
1400: , L.ACCOUNTING_RULE_DURATION
1401: , L.ACTUAL_ARRIVAL_DATE
1402: , L.AGREEMENT_ID
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
1724: AND nvl(l.error_flag,'N') = 'N'
1725: AND nvl(l.rejected_flag,'N') = 'N'
1726: AND l.line_id = t.line_id(+)
1727: UNION ALL
1728: SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1729: NULL ACCOUNTING_RULE_ID
1730: , NULL ACCOUNTING_RULE_DURATION
1731: , NULL ACTUAL_ARRIVAL_DATE
1732: -- , NULL ACTUAL_SHIPMENT_DATE
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