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_UC_POS_NECES_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 1210: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi

1206: where subject_id = c_instance_id
1207: and relationship_type_code = 'COMPONENT-OF'
1208: and trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1209: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))) parent_instance_id
1210: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi
1211: WHERE csi.INSTANCE_ID = c_instance_id
1212: AND reln.relationship_id = c_mc_relationship_id
1213: AND iasso.item_group_id = reln.item_group_id
1214: AND iasso.inventory_item_id = CSI.INVENTORY_ITEM_ID

Line 1545: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi

1541: where subject_id = c_instance_id
1542: and relationship_type_code = 'COMPONENT-OF'
1543: and trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1544: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))) parent_instance_id
1545: FROM ahl_mc_relationships reln, ahl_item_associations_b iasso, csi_item_instances csi
1546: WHERE csi.INSTANCE_ID = c_instance_id
1547: AND reln.relationship_id = c_mc_relationship_id
1548: AND iasso.item_group_id = reln.item_group_id
1549: AND iasso.inventory_item_id = CSI.INVENTORY_ITEM_ID