[Home] [Help]
1619: -- Load the model records from the order import interface tables. For importing
1620: -- pre-created configurations, users will specify CRN(config_rev_nbr),
1621: -- CHI(config_header_id) and either CI(configuration_id) or CC (component_code)
1622: -- If p_validate_configuration = Y Then use cursor c_line_config1 that has extra
1623: -- joins to CZ_CONFIG_DETAILS_V Z, OE_ACTIONS_INTERFACE a. These are needed
1624: -- to derive extra attributes that are needed for CZ batch validation API.
1625: -- Else then use cursor c_line_config2
1626: --
1627: CURSOR c_line_config1 IS
1643: nvl(l.component_code, z.component_code) component_code
1644: FROM OE_HEADERS_IFACE_ALL H,
1645: OE_LINES_IFACE_ALL L ,
1646: CZ_CONFIG_DETAILS_V Z,
1647: OE_ACTIONS_INTERFACE a
1648: WHERE h.batch_id = p_batch_id
1649: AND h.order_source_id = l.order_source_id
1650: AND h.orig_sys_document_ref = l.orig_sys_document_ref
1651: AND nvl(h.error_flag,'N') = 'N'
2150: nvl(h.booked_flag,decode(a.order_source_id,NULL,'N','Y')) booked_flag,
2151: 'N' cz_qty_match_flag
2152: FROM OE_HEADERS_IFACE_ALL H,
2153: OE_LINES_IFACE_ALL L,
2154: OE_ACTIONS_INTERFACE a
2155: WHERE h.batch_id = p_batch_id
2156: AND h.order_source_id = l.order_source_id
2157: AND h.orig_sys_document_ref = l.orig_sys_document_ref
2158: AND nvl(h.error_flag,'N') = 'N'