[Home] [Help]
APPS.AHL_AVF_PRIM_VSTS_PVT dependencies on AHL_MR_ORGANIZATIONS
Line 861: AHL_MR_ORGANIZATIONS MROrg,
857: HRU.NAME MAINTENANCE_ORG_NAME,
858: MROrg.MAINTENANCE_DEPT_ID,
859: ADSV.DEPT_DESCRIPTION MAINTENANCE_DEPT_NAME
860: FROM AHL_MR_HEADERS_B AMH,
861: AHL_MR_ORGANIZATIONS MROrg,
862: HR_ORGANIZATION_UNITS HRU,
863: AHL_DEPARTMENT_SHIFTS_V ADSV
864: WHERE MROrg.MR_TITLE = AMH.TITLE
865: AND MROrg.MAINTENANCE_ORG_ID = HRU.ORGANIZATION_ID