APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on MTL_SYSTEM_ITEMS

Line 147: AND NOT EXISTS (select 1 from mtl_system_items msi

143: error_code = 'CST_INVALID_ITEM_ID',
144: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ITEMID'),1,240)
145: where group_id = SEQ_NEXTVAL
146: AND error_flag is null
147: AND NOT EXISTS (select 1 from mtl_system_items msi
148: where ct.organization_id = msi.organization_id
149: AND ct.inventory_item_id = msi.inventory_item_id
150: );
151: fnd_file.put_line(fnd_file.log,'done checking for invalid inventory_item_id');

Line 171: OR EXISTS(select 1 from mtl_system_items msi

167: ct.error_explanation = substrb(fnd_message.get_string('BOM','CST_NOT_INVASSITEM'),1,240)
168: WHERE ct.error_flag is null
169: AND ct.group_id = SEQ_NEXTVAL
170: AND ((ct.inventory_asset_flag <> 1)
171: OR EXISTS(select 1 from mtl_system_items msi
172: where msi.inventory_item_id = ct.inventory_item_id
173: and msi.organization_id = ct.organization_id
174: and msi.inventory_asset_flag = 'N'
175: ));