819: AHL_VISITS_B AVTB,
820: AHL_VISITS_TL AVTT,
821: MTL_PARAMETERS MP,
822: BOM_DEPARTMENTS BDPT,
823: FND_LOOKUP_VALUES_VL FLVT,
824: FND_LOOKUP_VALUES_VL FNVS
825: WHERE
826: AVTB.VISIT_ID = P_VISIT_ID
827: AND AVTB.VISIT_ID = AVTT.VISIT_ID
820: AHL_VISITS_TL AVTT,
821: MTL_PARAMETERS MP,
822: BOM_DEPARTMENTS BDPT,
823: FND_LOOKUP_VALUES_VL FLVT,
824: FND_LOOKUP_VALUES_VL FNVS
825: WHERE
826: AVTB.VISIT_ID = P_VISIT_ID
827: AND AVTB.VISIT_ID = AVTT.VISIT_ID
828: AND AVTT.LANGUAGE = USERENV('LANG')