APPS.CSI_GIS_INSTANCE_LOC_UTL_PKG dependencies on MFG_LOOKUPS

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