APPS.AHL_FMP_PVT dependencies on CSI_LOOKUPS

Line 25: (select f.meaning from csi_lookups f where ii.instance_usage_code = f.lookup_code

21: ii.inventory_item_id,
22: ahl_util_uc_pkg.getcsi_locationDesc(ii.location_id, ii.location_type_code,
23: ii.inv_organization_id, ii.inv_subinventory_name,
24: ii.inv_locator_id, ii.wip_job_id) Location_description,
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,