APPS.AHL_PRD_DF_PVT dependencies on CSI_ITEM_INSTANCES

Line 949: FROM ahl_unit_effectivities_b ue, csi_item_instances cii

945: -- SR Cancellation for nonserialized items.
946: CURSOR is_orig_ue_nonserial(p_ue_id in number)
947: IS
948: SELECT cii.serial_number
949: FROM ahl_unit_effectivities_b ue, csi_item_instances cii
950: WHERE unit_effectivity_id in (select originator_ue_id
951: from ahl_ue_relationships
952: where related_ue_id = p_ue_id)
953: AND ue.csi_item_instance_id = cii.instance_id

Line 958: l_serial_number csi_item_instances.serial_number%TYPE;

954: AND cii.quantity > 1
955: AND ue.object_type = 'SR';
956:
957: l_exists VARCHAR2(1);
958: l_serial_number csi_item_instances.serial_number%TYPE;
959:
960: BEGIN
961:
962: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 3786: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO

3782:
3783: -- fix for bug number 6990380
3784: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
3785: SELECT 'x'
3786: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO
3787: WHERE CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
3788: AND AWO.workorder_id = p_workorder_id
3789: AND ACTIVE_START_DATE <= SYSDATE
3790: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))