APPS.AHL_COMPLETIONS_PVT dependencies on CSI_ITEM_INSTANCES

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

249: NVL(VTS.instance_id, VST.item_instance_id),
250: CSI.lot_number,
251: CSI.serial_number,
252: CSI.quantity
253: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
254: AHL_UNIT_EFFECTIVITIES_B UE
255: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
256: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
257: AND VST.visit_id = VTS.visit_id

Line 265: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,

261: SELECT nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id ),
262: CSI.lot_number,
263: CSI.serial_number,
264: CSI.quantity
265: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,
266: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST
267: WHERE nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id )= CSI.INSTANCE_ID
268: AND VST.visit_id = c_visit_id;
269:

Line 10457: CSI_ITEM_INSTANCES CII,

10453: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
10454: SELECT
10455: 'x'
10456: FROM
10457: CSI_ITEM_INSTANCES CII,
10458: AHL_WORKORDERS AWO
10459: WHERE
10460: CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
10461: AND AWO.workorder_id = p_workorder_id