[Home] [Help]
258: WO.MASTER_WORKORDER_FLAG MASTER_WORKORDER_FLAG,
259: VST.PROJECT_ID PROJECT_ID,
260: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,
261: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
262: FROM AHL_WORKORDERS WO,
263: AHL_VISITS_B VST,
264: AHL_VISIT_TASKS_B VTS,
265: WIP_DISCRETE_JOBS WIP
266: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
528: FND_LOOKUP_VALUES LKUP4,
529: AHL_VWP_STAGES_VL ASTG,
530: MTL_SYSTEM_ITEMS_B_KFV MTSB,
531: AHL_ROUTES_B ARV,
532: AHL_WORKORDERS AWO
533: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
534: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
535: AND ATSK.MR_ROUTE_ID = AMRR.MR_ROUTE_ID (+)
536: AND AMRR.MR_HEADER_ID= AMRH.MR_HEADER_ID (+)
624: FND_LOOKUP_VALUES LKUP1,
625: FND_LOOKUP_VALUES LKUP2,
626: FND_LOOKUP_VALUES LKUP3,
627: MTL_SYSTEM_ITEMS_B_KFV MTSB,
628: AHL_WORKORDERS AWO
629: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
630: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
631: AND ATSK.SERVICE_REQUEST_ID = SR.INCIDENT_ID(+)
632: AND ATSK.UNIT_EFFECTIVITY_ID = AUEF.UNIT_EFFECTIVITY_ID(+)
711: FND_LOOKUP_VALUES_VL LKUP1,
712: FND_LOOKUP_VALUES_VL LKUP2,
713: FND_LOOKUP_VALUES_VL LKUP3,
714: MTL_SYSTEM_ITEMS_B_KFV MTSB,
715: AHL_WORKORDERS AWO
716: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
717: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
718: AND ATSK.SERVICE_REQUEST_ID = SR.INCIDENT_ID(+)
719: AND ATSK.INVENTORY_ITEM_ID = MTSB.INVENTORY_ITEM_ID(+)
811: SELECT
812: /* scheduled_start_date,
813: scheduled_end_date
814: FROM
815: ahl_workorders_v
816: WHERE visit_id = p_visit_id
817: AND visit_task_id = p_visit_task_id;
818: */
819: -- AnRaj: Changed query for perf issue#2, Bug 4919465
819: -- AnRaj: Changed query for perf issue#2, Bug 4919465
820: wdj.scheduled_start_date scheduled_start_date,
821: wdj.scheduled_completion_date scheduled_end_date
822: FROM wip_discrete_jobs wdj,
823: ahl_workorders wo
824: WHERE wdj.wip_entity_id = wo.wip_entity_id
825: AND visit_id = p_visit_id
826: AND visit_task_id = p_visit_task_id;
827:
3034: l_old_Task_rec c_visit_task_det%rowtype;
3035:
3036: -- To find if WIP job is created for the Visit
3037: CURSOR c_job(x_id IN NUMBER) IS
3038: SELECT COUNT(*) FROM AHL_WORKORDERS
3039: WHERE VISIT_ID = x_id
3040: AND MASTER_WORKORDER_FLAG = 'Y'
3041: AND STATUS_CODE = 17;
3042:
3040: AND MASTER_WORKORDER_FLAG = 'Y'
3041: AND STATUS_CODE = 17;
3042:
3043: CURSOR c_Task_WO(x_task_id IN NUMBER) IS
3044: SELECT * FROM AHL_WORKORDERS
3045: WHERE VISIT_TASK_ID = x_task_id
3046: AND STATUS_CODE = 17;
3047: l_task_workrec c_Task_WO%ROWTYPE;
3048:
4941: FROM wip_discrete_jobs WHERE wip_entity_id =
4942: (
4943: SELECT
4944: wip_entity_id
4945: FROM ahl_workorders
4946: WHERE
4947: master_workorder_flag = 'Y' AND
4948: visit_task_id IS null AND
4949: status_code not in (22,7) and
5406:
5407: -- To find if WIP job is created for the Visit
5408: CURSOR c_wo_exist(x_task_id IN NUMBER)
5409: IS
5410: select 'X' from ahl_workorders
5411: where VISIT_TASK_ID=x_task_id;
5412:
5413: -- To find if WIP job is created for the Visit
5414: CURSOR c_workorders(x_task_id IN NUMBER)
5412:
5413: -- To find if WIP job is created for the Visit
5414: CURSOR c_workorders(x_task_id IN NUMBER)
5415: IS
5416: SELECT * FROM AHL_WORKORDERS
5417: WHERE VISIT_TASK_ID=x_task_id
5418: AND STATUS_CODE<>'22' AND STATUS_CODE<> '7';
5419:
5420: l_workrec c_workorders%ROWTYPE;
5805: AND T.VISIT_TASK_ID = x_id;
5806:
5807: -- To find if WIP job is created for the Visit
5808: CURSOR c_workorders(x_task_id IN NUMBER) IS
5809: SELECT * FROM AHL_WORKORDERS
5810: WHERE VISIT_TASK_ID=x_task_id
5811: AND STATUS_CODE<>'22' AND STATUS_CODE<> '7';
5812: c_workrec c_workorders%ROWTYPE;
5813:
6250: AND T.VISIT_TASK_ID = x_id;
6251:
6252: -- To find if WIP job is created for the Visit
6253: CURSOR c_workorders(x_task_id IN NUMBER) IS
6254: SELECT * FROM AHL_WORKORDERS
6255: WHERE VISIT_TASK_ID=x_task_id
6256: AND STATUS_CODE <> '22' AND STATUS_CODE <> '7';
6257: c_workrec c_workorders%ROWTYPE;
6258: