586: AHL_VWP_STAGES_VL ASTG,
587: MTL_SYSTEM_ITEMS_B_KFV MTSB,
588: AHL_ROUTES_B ARV,
589: AHL_WORKORDERS AWO,
590: PA_LOOKUPS PA
591: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
592: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
593: AND ATSK.MR_ROUTE_ID = AMRR.MR_ROUTE_ID (+)
594: AND AMRR.MR_HEADER_ID= AMRH.MR_HEADER_ID (+)
711: FND_LOOKUP_VALUES LKUP2,
712: FND_LOOKUP_VALUES LKUP3,
713: MTL_SYSTEM_ITEMS_B_KFV MTSB,
714: AHL_WORKORDERS AWO,
715: PA_LOOKUPS PA
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.UNIT_EFFECTIVITY_ID = AUEF.UNIT_EFFECTIVITY_ID(+)
827: FND_LOOKUP_VALUES_VL LKUP2,
828: FND_LOOKUP_VALUES_VL LKUP3,
829: MTL_SYSTEM_ITEMS_B_KFV MTSB,
830: AHL_WORKORDERS AWO,
831: PA_LOOKUPS PA
832: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
833: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
834: AND ATSK.SERVICE_REQUEST_ID = SR.INCIDENT_ID(+)
835: AND ATSK.INVENTORY_ITEM_ID = MTSB.INVENTORY_ITEM_ID(+)