[Home] [Help]
138: -- SATHAPLI::Component Maintenance Planning Project, 14-Nov-2011
139: -- cursor to check whether the workorder visit is a Component Visit
140: CURSOR chk_comp_visit_csr (c_workorder_id NUMBER) IS
141: SELECT 'X'
142: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
143: WHERE WO.workorder_id = c_workorder_id
144: AND TSK.visit_task_id = WO.visit_task_id
145: AND AHL_CMP_UTIL_PKG.Is_Comp_Visit(TSK.visit_id) = 'Y';
146:
1357: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
1358: FROM
1359: AHL_WORKORDERS AWOS,
1360: AHL_VISITS_B VST,
1361: AHL_VISIT_TASKS_B VTS
1362: WHERE
1363: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1364: VST.VISIT_ID = VTS.VISIT_ID AND
1365: WORKORDER_ID = p_workorder_id;
4182: l_inactive_item_found BOOLEAN;
4183: l_junk VARCHAR2(1);
4184:
4185: CURSOR is_open_job_instance_csr(p_instance_id IN NUMBER) IS
4186: SELECT 'x' from ahl_visit_tasks_b VST, ahl_workorders WO where
4187: VST.instance_id = p_instance_id
4188: AND VST.visit_task_id = WO.visit_task_id
4189: AND VST.visit_id = WO.visit_id
4190: AND WO.status_code NOT IN ('4','5','7','12','17','22');
4774: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
4775: FROM
4776: AHL_WORKORDERS AWOS,
4777: AHL_VISITS_B VST,
4778: AHL_VISIT_TASKS_B VTS
4779: WHERE
4780: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
4781: VST.VISIT_ID = VTS.VISIT_ID AND
4782: WORKORDER_ID = p_workorder_id;
5030: IS
5031: SELECT MTL.RESERVATION_ID RESERVATION_ID
5032: FROM MTL_RESERVATIONS MTL,
5033: AHL_WORKORDERS AWO,
5034: AHL_VISIT_TASKS_B AVT,
5035: AHL_WORKORDER_TASKS_V AWT
5036: WHERE AWO.WORKORDER_ID = AWT.WORKORDER_ID
5037: AND AWO.WIP_ENTITY_ID = AWT.WIP_ENTITY_ID
5038: AND AWO.VISIT_TASK_ID = AVT.VISIT_TASK_ID