APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on CSI_ITEM_INSTANCES

Line 951: FROM csi_item_instances ii

947: AND f.lookup_type = 'CSI_INSTANCE_USAGE_CODE') Status,
948: (select p.party_name from csi_inst_party_details_v p
949: where p.instance_id = ii.instance_id and p.relationship_type_code = 'OWNER') owner_name,
950: (select mat.description from mtl_material_statuses mat where ii.INSTANCE_CONDITION_ID = mat.status_id) condition
951: FROM csi_item_instances ii
952: WHERE ii.instance_id = c_item_instance_id;
953:
954: l_sequence NUMBER := 0;
955: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;