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(+)