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_VWP_PLAN_TASKS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 1174: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_B

1170:
1171: -- Begin changes by rnahata for Issue 105
1172: --Cursor to fetch the instance id when effectivity is given
1173: CURSOR c_get_prev_instance_id (p_unit_effectivity IN NUMBER) IS
1174: SELECT csi_item_instance_id FROM AHL_UNIT_EFFECTIVITIES_B
1175: WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity;
1176:
1177: --Cursor to fetch instance quantity
1178: CURSOR c_get_instance_qty(p_unit_effectivity IN NUMBER) IS

Line 1180: FROM csi_item_instances csii, ahl_unit_effectivities_b ue

1176:
1177: --Cursor to fetch instance quantity
1178: CURSOR c_get_instance_qty(p_unit_effectivity IN NUMBER) IS
1179: SELECT csii.quantity, ue.csi_item_instance_id
1180: FROM csi_item_instances csii, ahl_unit_effectivities_b ue
1181: WHERE ue.unit_effectivity_id = p_unit_effectivity
1182: AND csii.instance_id = ue.csi_item_instance_id;
1183:
1184: -- SKPATHAK :: Bug 9971127 :: 13-AUG-2010