[Home] [Help]
4739: WDJ.SCHEDULED_START_DATE,
4740: WDJ.SCHEDULED_COMPLETION_DATE
4741: FROM AHL_MR_HEADERS_B AMH,
4742: AHL_WORKORDERS AW,
4743: AHL_VISITS_B AV,
4744: AHL_VISIT_TASKS_B AVT,
4745: wip_discrete_jobs wdj
4746: WHERE AW.VISIT_TASK_ID = AVT.VISIT_TASK_ID
4747: AND AV.VISIT_ID = AVT.VISIT_ID
6874: BOMD.description department_name
6875:
6876: FROM AHL_VISIT_TASKS_B AVTB,
6877: AHL_WORKORDERS AHLW,
6878: AHL_VISITS_B AVB,
6879: BOM_DEPARTMENTS BOMD
6880:
6881: WHERE ( AVTB.stage_id = c_stage_id OR
6882: (c_stage_id = 0 AND AVTB.visit_id = c_visit_id AND AVTB.stage_id IS NULL) )
8371: awo.status_code,
8372: awo.wip_entity_id,
8373: awo.workorder_name,
8374: vst.visit_number
8375: FROM AHL_WORKORDERS AWO, AHL_VISITS_B VST
8376: WHERE awo.visit_id = c_visit_id
8377: AND awo.visit_id = vst.visit_id
8378: AND awo.status_code NOT IN (G_JOB_STATUS_DELETED,G_JOB_STATUS_CANCELLED)
8379: AND awo.visit_task_id IS NULL;
9914:
9915: CURSOR validate_visit(c_visit_id NUMBER)
9916: IS
9917: SELECT 1
9918: FROM AHL_VISITS_B
9919: WHERE VISIT_ID=c_visit_id;
9920:
9921: CURSOR check_workorder_exists(c_visit_id NUMBER)
9922: IS
10807: DECODE(WO.MASTER_WORKORDER_FLAG,'Y',to_number(NULL),VTS.PROJECT_TASK_ID) PROJECT_TASK_ID,
10808: WDJ.PRIORITY PRIORITY
10809: FROM
10810: AHL_WORKORDERS WO,
10811: AHL_VISITS_B VST,
10812: AHL_VISIT_TASKS_B VTS,
10813: WIP_DISCRETE_JOBS WDJ,
10814: CSI_ITEM_INSTANCES CSI
10815: WHERE
11776: -- Fetch visit task id also
11777: awo.visit_task_id
11778: FROM
11779: ahl_workorders awo,
11780: ahl_visits_b vst
11781: WHERE
11782: awo.visit_id = vst.visit_id
11783: AND vst.status_code not in ('CANCELLED', 'DELETED')
11784: AND vst.visit_id = p_visit_id
11792: IS
11793: SELECT
11794: vst.visit_id
11795: FROM
11796: ahl_visits_b vst
11797: WHERE
11798: vst.status_code not in ('CANCELLED', 'DELETED', 'DRAFT')
11799: AND vst.department_id = nvl(p_department_id, vst.department_id)
11800: AND vst.organization_id = nvl(p_organization_id, vst.organization_id);
11974:
11975: CURSOR get_contract_id ( c_contract_number NUMBER, c_visit_task_id NUMBER) IS
11976: SELECT WARRANTY_CONTRACT_ID
11977: FROM AHL_WARRANTY_CONTRACTS_B AWCB,
11978: AHL_VISITS_B VST,
11979: AHL_VISIT_TASKS_B VTS
11980: WHERE VTS.VISIT_TASK_ID = c_visit_task_id
11981: AND VTS.VISIT_ID = VST.VISIT_ID
11982: AND NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID) = AWCB.ITEM_INSTANCE_ID
12156: CURSOR Get_Wo_Cur_Values(c_workorder_id NUMBER) IS
12157: --sukhwsin::Bug 12915297. Removed Hold Reason.
12158: --select wo.status_code, wo.hold_reason_code, vst.organization_id
12159: select wo.status_code, vst.organization_id
12160: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts
12161: where
12162: wo.visit_task_id = vts.visit_task_id
12163: and vts.visit_id = vst.visit_id
12164: and wo.workorder_id = c_workorder_id;
12164: and wo.workorder_id = c_workorder_id;
12165: --Cursor to get Operation organization_id, seq_num and status_code
12166: CURSOR Get_Op_Details(c_workorder_op_id NUMBER) IS
12167: select vst.organization_id, oper.operation_sequence_num, oper.status_code, wo.workorder_id
12168: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts,ahl_workorder_operations oper
12169: where
12170: wo.visit_task_id = vts.visit_task_id
12171: and vts.visit_id = vst.visit_id
12172: and oper.workorder_id = wo.workorder_id
12356: AND vtsk.visit_task_id = c_visit_task_id;
12357:
12358: CURSOR get_uc_from_visit(c_visit_id NUMBER) IS
12359: Select UNIT_CONFIG_HEADER_ID from
12360: AHL_UNIT_CONFIG_HEADERS UC, AHL_VISITS_B V
12361: where V.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID
12362: AND V.ITEM_INSTANCE_ID = c_visit_id;
12363:
12364: l_unit_effectivity_id NUMBER := NULL;