PJF_RBS_VERSIONS_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
RBS_VERSION_ID NAME DESCRIPTION VERSION_NUMBER RBS_HEADER_ID START_DATE_ACTIVE END_DATE_ACTIVE JOB_SET_ID STATUS_CODE CURRENT_REPORTING_FLAG LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.RBS_Version_Id, TL.NAME, TL.DESCRIPTION, B.VERSION_NUMBER, B.RBS_HEADER_ID, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.JOB_SET_ID, B.STATUS_CODE, B.Current_Reporting_Flag, B.Last_Updated_By, B.Last_Update_Date, B.Creation_Date, B.CREATED_BY, B.Last_Update_Login, B.Object_Version_Number FROM PJF_RBS_VERSIONS_B B, PJF_RBS_VERSIONS_TL TL WHERE B.RBS_Version_Id = TL.RBS_Version_Id And TL.Language = userenv('lang')