PJT_REQUIREMENTS_VL

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name

RQMT_ID RQMT_CODE PARENT_RQMT_ID RQMT_LEVEL_ID RANK PRIORITY_CODE PARENT_RQMT_LEVEL1_ID PARENT_RQMT_LEVEL2_ID PARENT_RQMT_LEVEL3_ID PARENT_RQMT_LEVEL4_ID PARENT_RQMT_LEVEL5_ID RELEASE_ID PRODUCT_ID SPRINT_ID MILESTONE_CODE EFFORT STORYPOINTS STATUS ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RQMT_NAME RQMT_DESC LANGUAGE RQMT_SEARCH_TEXT OWNER_ID PROJECT_ID EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 USER_STORY ADDITIONAL_DETAILS EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 SCRUM_MASTER_ID

Query

SQL_Statement

SELECT PJT_REQUIREMENTS_B.RQMT_ID RQMT_ID, PJT_REQUIREMENTS_B.RQMT_CODE RQMT_CODE, PJT_REQUIREMENTS_B.PARENT_RQMT_ID PARENT_RQMT_ID, PJT_REQUIREMENTS_B.RQMT_LEVEL_ID RQMT_LEVEL_ID, PJT_REQUIREMENTS_B.RANK RANK, PJT_REQUIREMENTS_B.PRIORITY_CODE PRIORITY_CODE, PJT_REQUIREMENTS_B.PARENT_RQMT_LEVEL1_ID PARENT_RQMT_LEVEL1_ID, PJT_REQUIREMENTS_B.PARENT_RQMT_LEVEL2_ID PARENT_RQMT_LEVEL2_ID, PJT_REQUIREMENTS_B.PARENT_RQMT_LEVEL3_ID PARENT_RQMT_LEVEL3_ID, PJT_REQUIREMENTS_B.PARENT_RQMT_LEVEL4_ID PARENT_RQMT_LEVEL4_ID, PJT_REQUIREMENTS_B.PARENT_RQMT_LEVEL5_ID PARENT_RQMT_LEVEL5_ID, PJT_REQUIREMENTS_B.RELEASE_ID RELEASE_ID, PJT_REQUIREMENTS_B.PRODUCT_ID PRODUCT_ID, PJT_REQUIREMENTS_B.SPRINT_ID SPRINT_ID, PJT_REQUIREMENTS_B.MILESTONE_CODE MILESTONE_CODE, PJT_REQUIREMENTS_B.EFFORT EFFORT, PJT_REQUIREMENTS_B.STORYPOINTS STORYPOINTS, PJT_REQUIREMENTS_B.STATUS STATUS, PJT_REQUIREMENTS_B.ENTERPRISE_ID ENTERPRISE_ID, PJT_REQUIREMENTS_B.CREATED_BY CREATED_BY, PJT_REQUIREMENTS_B.CREATION_DATE CREATION_DATE, PJT_REQUIREMENTS_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJT_REQUIREMENTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJT_REQUIREMENTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJT_REQUIREMENTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJT_REQUIREMENTS_TL.RQMT_NAME RQMT_NAME, PJT_REQUIREMENTS_TL.RQMT_DESC RQMT_DESC, PJT_REQUIREMENTS_TL.LANGUAGE LANGUAGE, PJT_REQUIREMENTS_TL.RQMT_SEARCH_TEXT RQMT_SEARCH_TEXT, PJT_REQUIREMENTS_B.OWNER_ID OWNER_ID, PJT_REQUIREMENTS_B.PROJECT_ID PROJECT_ID, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005, PJT_REQUIREMENTS_TL.USER_STORY USER_STORY, PJT_REQUIREMENTS_TL.ADDITIONAL_DETAILS ADDITIONAL_DETAILS, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP011, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_TIMESTAMP012, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP013, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP014, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_TIMESTAMP015, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP016, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP017, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_TIMESTAMP018, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP019, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_TIMESTAMP020, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099, PJT_REQUIREMENTS_B.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100, PJT_REQUIREMENTS_B.SCRUM_MASTER_ID SCRUM_MASTER_ID FROM PJT_REQUIREMENTS_B, PJT_REQUIREMENTS_TL WHERE PJT_REQUIREMENTS_B.RQMT_ID = PJT_REQUIREMENTS_TL.RQMT_ID AND PJT_REQUIREMENTS_TL.LANGUAGE = USERENV('LANG')