PJE_ISSUE_TYPES_VL

Details

• Schema: FUSION

• Object owner: PJE

• Object type: VIEW

Columns

Name

ENTERPRISE_ID ISSUE_TYPE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER START_DATE_ACTIVE END_DATE_ACTIVE DISABLED NAME DESCRIPTION EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 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_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_CHAR029 EXTN_ATTRIBUTE_CHAR030

Query

SQL_Statement

SELECT PJE_ISSUE_TYPES_B.ENTERPRISE_ID ENTERPRISE_ID, PJE_ISSUE_TYPES_B.ISSUE_TYPE_ID ISSUE_TYPE_ID, PJE_ISSUE_TYPES_B.CREATED_BY CREATED_BY, PJE_ISSUE_TYPES_B.CREATION_DATE CREATION_DATE, PJE_ISSUE_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJE_ISSUE_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJE_ISSUE_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJE_ISSUE_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJE_ISSUE_TYPES_B.START_DATE_ACTIVE START_DATE_ACTIVE, PJE_ISSUE_TYPES_B.END_DATE_ACTIVE END_DATE_ACTIVE, PJE_ISSUE_TYPES_B.DISABLED, PJE_ISSUE_TYPES_TL.NAME NAME, PJE_ISSUE_TYPES_TL.DESCRIPTION DESCRIPTION, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_TIMESTAMP001, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_TIMESTAMP002, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_TIMESTAMP003, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_TIMESTAMP004, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_TIMESTAMP005, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_NUMBER001, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_NUMBER002, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_NUMBER003, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_NUMBER004, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_NUMBER005, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR001, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR002, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR003, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR004 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR005 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR006 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR007 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR008 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR009 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR010 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR011 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR012 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR013 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR014 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR015 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR016 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR017 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR018 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR019 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR020 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR021 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR022 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR023 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR024 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR025 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR026 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR027 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR028 , PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR029, PJE_ISSUE_TYPES_B.EXTN_ATTRIBUTE_CHAR030 FROM PJE_ISSUE_TYPES_B, PJE_ISSUE_TYPES_TL WHERE PJE_ISSUE_TYPES_B.ISSUE_TYPE_ID = PJE_ISSUE_TYPES_TL.ISSUE_TYPE_ID AND PJE_ISSUE_TYPES_B.ENTERPRISE_ID=PJE_ISSUE_TYPES_TL.ENTERPRISE_ID AND PJE_ISSUE_TYPES_TL.LANGUAGE = USERENV('LANG')