[Home] [Help]
509: ASPL.SPACE_NAME,
510: ASPL.BOM_DEPARTMENT_ID DEPARTMENT_ID,
511: ASPL.ORGANIZATION_ID,
512: BDPT.DESCRIPTION DEPT_DESCRIPTION
513: FROM AHL_SPACES_VL ASPL,
514: BOM_DEPARTMENTS BDPT
515: WHERE ASPL.BOM_DEPARTMENT_ID = BDPT.DEPARTMENT_ID
516: AND ASPL.ORGANIZATION_ID = c_org_id
517: AND ASPL.INACTIVE_FLAG LIKE 'Y'