APPS.OE_BULK_CONFIG_UTIL dependencies on CZ_CONFIG_DETAILS_V

Line 1623: -- joins to CZ_CONFIG_DETAILS_V Z, OE_ACTIONS_INTERFACE a. These are needed

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

Line 1646: CZ_CONFIG_DETAILS_V Z,

1642: cz_qty_match_flag,
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

Line 1927: FROM cz_config_details_v z

1923: null MUTUALLY_EXCLUSIVE_OPTIONS,
1924: null BOM_ITEM_TYPE,
1925: null LOCK_CONTROL,
1926: null REPLENISH_TO_ORDER_FLAG
1927: FROM cz_config_details_v z
1928: WHERE z.config_hdr_id = l_line_rec.config_header_id(I)
1929: AND z.config_rev_nbr = l_line_rec.config_rev_nbr(I)
1930: AND NOT EXISTS (
1931: Select l.line_id

Line 2009: FROM cz_config_details_v z, oe_lines_iface_all l

2005: null MUTUALLY_EXCLUSIVE_OPTIONS,
2006: null BOM_ITEM_TYPE,
2007: l_line_rec.lock_control(I) LOCK_CONTROL,
2008: null REPLENISH_TO_ORDER_FLAG
2009: FROM cz_config_details_v z, oe_lines_iface_all l
2010: WHERE z.config_hdr_id = l_line_rec.config_header_id(I)
2011: AND z.config_rev_nbr = l_line_rec.config_rev_nbr(I)
2012: AND NVL(l.configuration_id,z.config_item_id) = z.config_item_id
2013: AND NVL(l.component_code, z.component_code) = z.component_code

Line 2776: -- cz_config_details_v for the new instance that just got created in

2772: ELSE -- Else If configurator is used Then
2773:
2774: -- We will need to first insert all records from l_line_rec and pull
2775: -- missing attributes (quantity, line_type, configuration_id ) from
2776: -- cz_config_details_v for the new instance that just got created in
2777: -- Batch Validation call.
2778:
2779: FORALL I in 1..l_line_rec.line_id.COUNT
2780: INSERT INTO oe_config_details_tmp

Line 2839: FROM CZ_CONFIG_DETAILS_V z

2835: --low_quantity(I)
2836: --mutually_exclusive_options(I)
2837: --bom_item_type(I)
2838: l_line_rec.lock_control(I)
2839: FROM CZ_CONFIG_DETAILS_V z
2840: WHERE z.config_hdr_id = l_line_rec.config_header_id(I)
2841: AND z.config_rev_nbr = l_line_rec.config_rev_nbr(I)
2842: AND z.component_code = l_line_rec.component_code(I);
2843:

Line 2905: FROM CZ_CONFIG_DETAILS_V z,

2901: L.top_bill_sequence_id,
2902: 'CLASS', -- In new configuration, only CLASS can be missing
2903: z.bom_item_type,
2904: null LOCK_CONTROL
2905: FROM CZ_CONFIG_DETAILS_V z,
2906: oe_config_details_tmp L
2907: WHERE L.item_type_code = 'MODEL'
2908: AND L.line_id = L.top_model_line_id
2909: AND nvl(L.lock_control, 0) <> -99