APPS.CTO_ITEM_PK dependencies on MTL_SYSTEM_ITEMS

Line 1796: where exists ( select organization_id from mtl_system_items msi

1792: v_config_item_status := 0 ;
1793:
1794: begin
1795: select 1 /* BCMO not in synch with Model Item */ into v_model_item_status from dual
1796: where exists ( select organization_id from mtl_system_items msi
1797: where not exists
1798: ( select organization_id from bom_cto_model_orgs bcmo
1799: where bcmo.config_item_id = lXConfigId
1800: and bcmo.organization_id = msi.organization_id )

Line 1813: where exists ( select organization_id from mtl_system_items model

1809:
1810:
1811: begin
1812: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual
1813: where exists ( select organization_id from mtl_system_items model
1814: where not exists
1815: ( select organization_id from mtl_system_items config
1816: where config.inventory_item_id = lXConfigId
1817: and config.organization_id = model.organization_id )

Line 1815: ( select organization_id from mtl_system_items config

1811: begin
1812: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual
1813: where exists ( select organization_id from mtl_system_items model
1814: where not exists
1815: ( select organization_id from mtl_system_items config
1816: where config.inventory_item_id = lXConfigId
1817: and config.organization_id = model.organization_id )
1818: and model.inventory_item_id = v_model_lines.inventory_item_id ) ;
1819:

Line 1842: from mtl_system_items_kfv

1838: oe_debug_pub.add ('Create_All_Items: ' || 'Error: Item Not Enabled in some orgs', 1);
1839: END IF;
1840:
1841: select concatenated_segments into v_model_item_name
1842: from mtl_system_items_kfv
1843: where inventory_item_id = v_model_lines.inventory_item_id
1844: and rownum = 1 ;
1845:
1846:

Line 1853: from mtl_system_items_kfv

1849:
1850:
1851:
1852: select concatenated_segments into v_config_item_name
1853: from mtl_system_items_kfv
1854: where inventory_item_id = lXConfigId
1855: and rownum = 1 ;
1856:
1857: