761: VB.ATTRIBUTE15,
762: VB.UNIT_SCHEDULE_ID
763: FROM AHL_VISITS_B VB,
764: AHL_UNIT_CONFIG_HEADERS UC,
765: HR_ALL_ORGANIZATION_UNITS HROU,
766: BOM_DEPARTMENTS BDPT
767: WHERE
768: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
769: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND
1024: VB.ATTRIBUTE15,
1025: VB.UNIT_SCHEDULE_ID
1026: FROM AHL_VISITS_B VB,
1027: AHL_UNIT_CONFIG_HEADERS UC,
1028: HR_ALL_ORGANIZATION_UNITS HROU,
1029: BOM_DEPARTMENTS BDPT
1030: WHERE
1031: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
1032: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND