DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_VISITS_B

Line 4640: AHL_VISITS_B VST,

4636: VST.project_id,
4637: VST.inv_locator_id,
4638: AWO.wip_entity_id
4639: FROM
4640: AHL_VISITS_B VST,
4641: AHL_WORKORDERS AWO
4642: WHERE
4643: VST.status_code NOT IN ('DELETED', 'CANCELLED')
4644: AND AWO.visit_id = VST.visit_id

Line 4741: AHL_VISITS_B VST

4737: FROM
4738: -- jaramana on Feb 14, 2008 for bug 6819370
4739: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4740: MTL_ITEM_LOCATIONS ILOC,
4741: AHL_VISITS_B VST
4742: WHERE
4743: ILOC.subinventory_code = C.inv_subinventory_name
4744: AND ILOC.organization_id = C.inv_organization_id
4745: AND (ILOC.end_date_active IS NULL OR ILOC.end_date_active >= SYSDATE)

Line 4880: AHL_VISITS_B VST

4876: FROM
4877: -- jaramana on Feb 14, 2008 for bug 6819370
4878: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4879: MTL_ITEM_LOCATIONS ILOC,
4880: AHL_VISITS_B VST
4881: WHERE
4882: ILOC.subinventory_code = C.inv_subinventory_name
4883: AND ILOC.organization_id = C.inv_organization_id
4884: AND (ILOC.end_date_active IS NULL OR ILOC.end_date_active >= SYSDATE)