APPS.CTO_ITEM_PK dependencies on MTL_SYSTEM_ITEMS

Line 1736: where exists ( select organization_id from mtl_system_items msi

1732: v_config_item_status := 0 ;
1733:
1734: begin
1735: select 1 /* BCMO not in synch with Model Item */ into v_model_item_status from dual
1736: where exists ( select organization_id from mtl_system_items msi
1737: where not exists
1738: ( select organization_id from bom_cto_model_orgs bcmo
1739: where bcmo.config_item_id = lXConfigId
1740: and bcmo.organization_id = msi.organization_id )

Line 1753: where exists ( select organization_id from mtl_system_items model

1749:
1750:
1751: begin
1752: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual
1753: where exists ( select organization_id from mtl_system_items model
1754: where not exists
1755: ( select organization_id from mtl_system_items config
1756: where config.inventory_item_id = lXConfigId
1757: and config.organization_id = model.organization_id )

Line 1755: ( select organization_id from mtl_system_items config

1751: begin
1752: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual
1753: where exists ( select organization_id from mtl_system_items model
1754: where not exists
1755: ( select organization_id from mtl_system_items config
1756: where config.inventory_item_id = lXConfigId
1757: and config.organization_id = model.organization_id )
1758: and model.inventory_item_id = v_model_lines.inventory_item_id ) ;
1759:

Line 1782: from mtl_system_items_kfv

1778: oe_debug_pub.add ('Create_All_Items: ' || 'Error: Item Not Enabled in some orgs', 1);
1779: END IF;
1780:
1781: select concatenated_segments into v_model_item_name
1782: from mtl_system_items_kfv
1783: where inventory_item_id = v_model_lines.inventory_item_id
1784: and rownum = 1 ;
1785:
1786:

Line 1793: from mtl_system_items_kfv

1789:
1790:
1791:
1792: select concatenated_segments into v_config_item_name
1793: from mtl_system_items_kfv
1794: where inventory_item_id = lXConfigId
1795: and rownum = 1 ;
1796:
1797: