PJT_RQMT_HIERARCHY_VL

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
RQMT_LEVEL_ID PARENT_RQMT_LEVEL_ID RQMT_LEVEL_TYPE OWNER_ID RELEASE_ID PRODUCT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RQMT_LEVEL_NAME RQMT_LEVEL_CODE STATUS_CODE PRIORITY_CODE

Query

SQL_Statement

SELECT PJT_RQMT_HIERARCHY_B.RQMT_LEVEL_ID RQMT_LEVEL_ID, PJT_RQMT_HIERARCHY_B.PARENT_RQMT_LEVEL_ID PARENT_RQMT_LEVEL_ID, PJT_RQMT_HIERARCHY_B.RQMT_LEVEL_TYPE RQMT_LEVEL_TYPE, PJT_RQMT_HIERARCHY_B.OWNER_ID OWNER_ID, PJT_RQMT_HIERARCHY_B.RELEASE_ID RELEASE_ID, PJT_RQMT_HIERARCHY_B.PRODUCT_ID PRODUCT_ID, PJT_RQMT_HIERARCHY_B.CREATED_BY CREATED_BY, PJT_RQMT_HIERARCHY_B.CREATION_DATE CREATION_DATE, PJT_RQMT_HIERARCHY_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJT_RQMT_HIERARCHY_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJT_RQMT_HIERARCHY_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJT_RQMT_HIERARCHY_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJT_RQMT_HIERARCHY_TL.RQMT_LEVEL_NAME RQMT_LEVEL_NAME, PJT_RQMT_HIERARCHY_B.RQMT_LEVEL_CODE RQMT_LEVEL_CODE, PJT_RQMT_HIERARCHY_B.STATUS_CODE STATUS_CODE, PJT_RQMT_HIERARCHY_B.PRIORITY_CODE PRIORITY_CODE FROM PJT_RQMT_HIERARCHY_B, PJT_RQMT_HIERARCHY_TL WHERE PJT_RQMT_HIERARCHY_B.RQMT_LEVEL_ID = PJT_RQMT_HIERARCHY_TL.RQMT_LEVEL_ID AND PJT_RQMT_HIERARCHY_TL.LANGUAGE = USERENV('LANG') ORDER BY PJT_RQMT_HIERARCHY_TL.RQMT_LEVEL_NAME ASC NULLS LAST