4614: VST.project_id,
4615: VST.inv_locator_id,
4616: AWO.wip_entity_id
4617: FROM
4618: AHL_VISITS_B VST,
4619: AHL_WORKORDERS AWO
4620: WHERE
4621: VST.status_code NOT IN ('DELETED', 'CANCELLED')
4622: AND AWO.visit_id = VST.visit_id
4703: FROM
4704: -- jaramana on Feb 14, 2008 for bug 6819370
4705: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4706: MTL_ITEM_LOCATIONS ILOC,
4707: AHL_VISITS_B VST
4708: WHERE
4709: ILOC.subinventory_code = C.inv_subinventory_name
4710: AND ILOC.organization_id = C.inv_organization_id
4711: AND (ILOC.end_date_active IS NULL OR ILOC.end_date_active >= SYSDATE)
4817: FROM
4818: -- jaramana on Feb 14, 2008 for bug 6819370
4819: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4820: MTL_ITEM_LOCATIONS ILOC,
4821: AHL_VISITS_B VST
4822: WHERE
4823: ILOC.subinventory_code = C.inv_subinventory_name
4824: AND ILOC.organization_id = C.inv_organization_id
4825: AND (ILOC.end_date_active IS NULL OR ILOC.end_date_active >= SYSDATE)