521: AHL_UNIT_EFFECTIVITIES_B AUEF,
522: CSI_ITEM_INSTANCES CSIS,
523: CS_INCIDENTS_ALL_B SR,
524: BOM_DEPARTMENTS BDPT,
525: FND_LOOKUP_VALUES LKUP1,
526: FND_LOOKUP_VALUES LKUP2,
527: FND_LOOKUP_VALUES LKUP3,
528: FND_LOOKUP_VALUES LKUP4,
529: AHL_VWP_STAGES_VL ASTG,
522: CSI_ITEM_INSTANCES CSIS,
523: CS_INCIDENTS_ALL_B SR,
524: BOM_DEPARTMENTS BDPT,
525: FND_LOOKUP_VALUES LKUP1,
526: FND_LOOKUP_VALUES LKUP2,
527: FND_LOOKUP_VALUES LKUP3,
528: FND_LOOKUP_VALUES LKUP4,
529: AHL_VWP_STAGES_VL ASTG,
530: MTL_SYSTEM_ITEMS_B_KFV MTSB,
523: CS_INCIDENTS_ALL_B SR,
524: BOM_DEPARTMENTS BDPT,
525: FND_LOOKUP_VALUES LKUP1,
526: FND_LOOKUP_VALUES LKUP2,
527: FND_LOOKUP_VALUES LKUP3,
528: FND_LOOKUP_VALUES LKUP4,
529: AHL_VWP_STAGES_VL ASTG,
530: MTL_SYSTEM_ITEMS_B_KFV MTSB,
531: AHL_ROUTES_B ARV,
524: BOM_DEPARTMENTS BDPT,
525: FND_LOOKUP_VALUES LKUP1,
526: FND_LOOKUP_VALUES LKUP2,
527: FND_LOOKUP_VALUES LKUP3,
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
620: CSI_ITEM_INSTANCES CSIS,
621: CS_INCIDENTS_ALL_B SR,
622: AHL_VWP_STAGES_VL ASTG,
623: BOM_DEPARTMENTS BDPT,
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
621: CS_INCIDENTS_ALL_B SR,
622: AHL_VWP_STAGES_VL ASTG,
623: BOM_DEPARTMENTS BDPT,
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 (+)
622: AHL_VWP_STAGES_VL ASTG,
623: BOM_DEPARTMENTS BDPT,
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(+)
707: CSI_ITEM_INSTANCES CSIS,
708: CS_INCIDENTS_ALL_B SR,
709: AHL_VWP_STAGES_VL ASTG,
710: BOM_DEPARTMENTS BDPT,
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
708: CS_INCIDENTS_ALL_B SR,
709: AHL_VWP_STAGES_VL ASTG,
710: BOM_DEPARTMENTS BDPT,
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 (+)
709: AHL_VWP_STAGES_VL ASTG,
710: BOM_DEPARTMENTS BDPT,
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(+)