PJF_RBS_HEADERS_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
RBS_HEADER_ID NAME DESCRIPTION RBS_TYPE CENTRALLY_CONTROL_FLAG PROJECT_UNIT_ID PROJECT_ID START_DATE_ACTIVE END_DATE_ACTIVE USE_FOR_ALLOC_FLAG USE_FOR_CMT_CTRL_FLAG USE_FOR_IC_BILLING_FLAG SOURCE_RBS_HEADER_ID LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT DISTINCT H.RBS_HEADER_ID, H.NAME, H.DESCRIPTION, H.RBS_TYPE, H.CENTRALLY_CONTROL_FLAG, H.PROJECT_UNIT_ID, H.PROJECT_ID, H.START_DATE_ACTIVE, H.END_DATE_ACTIVE, H.USE_FOR_ALLOC_FLAG, H.USE_FOR_CMT_CTRL_FLAG, H.USE_FOR_IC_BILLING_FLAG, H.SOURCE_RBS_HEADER_ID, H.LAST_UPDATED_BY, H.LAST_UPDATE_DATE, H.CREATION_DATE, H.CREATED_BY, H.LAST_UPDATE_LOGIN, H.OBJECT_VERSION_NUMBER FROM PJF_RBS_HEADERS_VL H, PJF_RBS_VERSIONS_VL V WHERE H.RBS_HEADER_ID = V.RBS_HEADER_ID AND V.STATUS_CODE ='FROZEN'