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_COMPLETIONS_PVT dependencies on CSI_ITEM_INSTANCES

Line 279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,

275: NVL(VTS.instance_id, VST.item_instance_id),
276: CSI.lot_number,
277: CSI.serial_number,
278: CSI.quantity
279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
280: AHL_UNIT_EFFECTIVITIES_B UE
281: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
282: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
283: AND VST.visit_id = VTS.visit_id

Line 291: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,

287: SELECT nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id ),
288: CSI.lot_number,
289: CSI.serial_number,
290: CSI.quantity
291: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,
292: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST
293: WHERE nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id )= CSI.INSTANCE_ID
294: AND VST.visit_id = c_visit_id;
295:

Line 11284: CSI_ITEM_INSTANCES CII,

11280: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
11281: SELECT
11282: 'x'
11283: FROM
11284: CSI_ITEM_INSTANCES CII,
11285: AHL_WORKORDERS AWO
11286: WHERE
11287: CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
11288: AND AWO.workorder_id = p_workorder_id