APPS.CSI_GIS_INSTANCE_LOC_UTL_PKG dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 71: From MFG_LOOKUPS ml1, MTL_SYSTEM_ITEMS_B_KFV msi,csi_item_instances cii

67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);
68: END IF;
69:
70: SELECT Nvl((SELECT 'EAM'
71: From MFG_LOOKUPS ml1, MTL_SYSTEM_ITEMS_B_KFV msi,csi_item_instances cii
72: where
73: msi.inventory_item_id = cii.inventory_item_id
74: AND cii.last_vld_organization_id=msi.organization_id
75: AND (cii.active_start_date IS NULL OR (cii.active_start_date <= sysdate))

Line 103: FROM MTL_SYSTEM_ITEMS_B_KFV

99: IF l_instance_type = 'EAM' THEN
100: csi_t_gen_utility_pvt.add( 'Validating EAM Asset');
101: SELECT EAM_ITEM_TYPE,SERIAL_NUMBER_CONTROL_CODE
102: INTO l_csi_item_type,l_serial_number_control_code
103: FROM MTL_SYSTEM_ITEMS_B_KFV
104: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
105: AND ORGANIZATION_ID = l_organization_id;
106:
107: