eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_PVT dependencies on MTL_MATERIAL_STATUSES

Line 29: (select mat.description from mtl_material_statuses mat where ii.INSTANCE_CONDITION_ID = mat.status_id) condition,

25: (select f.meaning from csi_lookups f where ii.instance_usage_code = f.lookup_code
26: AND f.lookup_type = 'CSI_INSTANCE_USAGE_CODE') Status,
27: (select p.party_name from csi_inst_party_details_v p
28: where p.instance_id = ii.instance_id and p.relationship_type_code = 'OWNER') owner_name,
29: (select mat.description from mtl_material_statuses mat where ii.INSTANCE_CONDITION_ID = mat.status_id) condition,
30: (select to_date(ciea.attribute_value, 'DD/MM/YYYY')
31: from csi_inst_extend_attrib_v ciea
32: where ciea.instance_id = ii.instance_id
33: AND ciea.attribute_code = 'AHL_MFG_DATE'