APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 814: segment1 mtl_system_items.segment1%type,

810: config_hdr_id cz_config_details_v.config_hdr_id%type,
811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,
812: inventory_item_id cz_config_details_v.inventory_item_id%type,
813: component_code cz_config_details_v.component_code%type,
814: segment1 mtl_system_items.segment1%type,
815: component_item_id bom_inventory_components.component_item_id%type,
816: component_sequence_id bom_inventory_components.component_sequence_id%type,
817: bom_item_type bom_inventory_components.bom_item_type%type,
818: wip_supply_type bom_inventory_components.wip_supply_type%type,

Line 820: config_orgs mtl_system_items.config_orgs%type,

816: component_sequence_id bom_inventory_components.component_sequence_id%type,
817: bom_item_type bom_inventory_components.bom_item_type%type,
818: wip_supply_type bom_inventory_components.wip_supply_type%type,
819: component_quantity bom_inventory_components.component_quantity%type,
820: config_orgs mtl_system_items.config_orgs%type,
821: config_match mtl_system_items.config_match%type,
822: uom_code cz_config_details_v.uom_code%type --bugfix 4605114
823: ) ;
824:

Line 821: config_match mtl_system_items.config_match%type,

817: bom_item_type bom_inventory_components.bom_item_type%type,
818: wip_supply_type bom_inventory_components.wip_supply_type%type,
819: component_quantity bom_inventory_components.component_quantity%type,
820: config_orgs mtl_system_items.config_orgs%type,
821: config_match mtl_system_items.config_match%type,
822: uom_code cz_config_details_v.uom_code%type --bugfix 4605114
823: ) ;
824:
825: TYPE config_data_tbl_type is table of config_data_rec_type INDEX by BINARY_INTEGER ;

Line 856: mtl_system_items msi

852: msi.config_match,
853: cz.uom_code --bugfix 4605114
854: from cz_config_details_v cz ,
855: bom_inventory_components bic,
856: mtl_system_items msi
857: where bic.component_sequence_id(+) = cz.component_sequence_id
858: AND msi.inventory_item_id = cz.inventory_item_id
859: AND cz.config_hdr_id = p_cz_config_hdr_id
860: AND cz.config_rev_nbr = p_cz_config_rev_num

Line 1749: from mtl_system_items

1745: -- of top model item id in validation org.
1746:
1747: select nvl(item_catalog_group_id,0)
1748: into licg_id
1749: from mtl_system_items
1750: where inventory_item_id = l_top_model_id
1751: and organization_id = lValidationOrg;
1752:
1753: oe_debug_pub.add ('Item Catalog Group Id : '||to_char(licg_id), 2) ;

Line 1759: update mtl_system_items

1755: -- If the model item has catalog , that catalog group id
1756: -- is copied to preconfig item in all org
1757:
1758: if licg_id <> 0 then
1759: update mtl_system_items
1760: set item_catalog_group_id = licg_id
1761: where inventory_item_id = lconfig_item_id
1762: and nvl(item_catalog_group_id,0) = 0; --Bugfix 6043798
1763: oe_debug_pub.add ('Updated catalog group id of preconfig item ' , 2) ;