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

Line 406: ahl_item_associations_b A

402: --Added DISTINCT to the following two queries for fixing bug 4102152, Jerry on 01/04/2005
403: SELECT distinct C.instance_id
404: FROM csi_item_instances C,
405: ahl_mc_relationships R,
406: ahl_item_associations_b A
407: WHERE C.instance_number = c_instance_num
408: AND R.relationship_id = c_relationship_id
409: AND R.item_group_id = A.item_group_id
410: AND C.inventory_item_id = A.inventory_item_id

Line 438: ahl_item_associations_b A

434: CURSOR get_rec_from_id(c_instance_id NUMBER, c_relationship_id NUMBER) IS
435: SELECT distinct C.instance_id
436: FROM csi_item_instances C,
437: ahl_mc_relationships R,
438: ahl_item_associations_b A
439: WHERE C.instance_id = c_instance_id
440: AND R.relationship_id = c_relationship_id
441: AND R.item_group_id = A.item_group_id
442: AND C.inventory_item_id = A.inventory_item_id