244: FROM
245: AHL_SEARCH_WORKORDERS_V A
246: --AHL_VISITS_B V,
247: --AHL_VISIT_TASKS_B VT,
248: --INV_ORGANIZATION_NAME_V ORG,
249: --FND_LOOKUP_VALUES WO_STS
250: WHERE
251: A.JOB_NUMBER = C_WORKORDER_NAME
252: AND A.JOB_STATUS_CODE NOT IN ('17', '22');
4567: AHL_VISITS_B V,
4568: AHL_VISIT_TASKS_B VT,
4569: CS_INCIDENTS_ALL_B C,
4570: WIP_DISCRETE_JOBS WDJ,
4571: INV_ORGANIZATION_NAME_V ORG,
4572: BOM_DEPARTMENTS B,
4573: AHL_WORKORDER_OPERATIONS O
4574: WHERE
4575: T.ORGANIZATION_ID = V.ORGANIZATION_ID