DBA Data[Home] [Help]

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');