DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_VISITS_B

Line 4618: AHL_VISITS_B VST,

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

Line 4707: AHL_VISITS_B VST

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)

Line 4821: AHL_VISITS_B VST

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)