PJE_DELIVERABLE_TYPES_VL

Details

• Schema: FUSION

• Object owner: PJE

• Object type: VIEW

Columns

Name

ENTERPRISE_ID DELIVERABLE_TYPE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DELIVERABLE_TYPE_CLASS 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 PDTB.ENTERPRISE_ID, PDTB.DELIVERABLE_TYPE_ID, PDTB.CREATED_BY, PDTB.CREATION_DATE, PDTB.LAST_UPDATED_BY, PDTB.LAST_UPDATE_DATE, PDTB.LAST_UPDATE_LOGIN, PDTB.OBJECT_VERSION_NUMBER, PDTB.DELIVERABLE_TYPE_CLASS, PDTB.START_DATE_ACTIVE, PDTB.END_DATE_ACTIVE, PDTB.DISABLED, PDTTL.NAME, PDTTL.DESCRIPTION, PDTB.EXTN_ATTRIBUTE_TIMESTAMP001, PDTB.EXTN_ATTRIBUTE_TIMESTAMP002, PDTB.EXTN_ATTRIBUTE_TIMESTAMP003, PDTB.EXTN_ATTRIBUTE_TIMESTAMP004, PDTB.EXTN_ATTRIBUTE_TIMESTAMP005, PDTB.EXTN_ATTRIBUTE_NUMBER001, PDTB.EXTN_ATTRIBUTE_NUMBER002, PDTB.EXTN_ATTRIBUTE_NUMBER003, PDTB.EXTN_ATTRIBUTE_NUMBER004, PDTB.EXTN_ATTRIBUTE_NUMBER005, PDTB.EXTN_ATTRIBUTE_CHAR001, PDTB.EXTN_ATTRIBUTE_CHAR002, PDTB.EXTN_ATTRIBUTE_CHAR003, PDTB.EXTN_ATTRIBUTE_CHAR004 , PDTB.EXTN_ATTRIBUTE_CHAR005 , PDTB.EXTN_ATTRIBUTE_CHAR006 , PDTB.EXTN_ATTRIBUTE_CHAR007 , PDTB.EXTN_ATTRIBUTE_CHAR008 , PDTB.EXTN_ATTRIBUTE_CHAR009 , PDTB.EXTN_ATTRIBUTE_CHAR010 , PDTB.EXTN_ATTRIBUTE_CHAR011 , PDTB.EXTN_ATTRIBUTE_CHAR012 , PDTB.EXTN_ATTRIBUTE_CHAR013 , PDTB.EXTN_ATTRIBUTE_CHAR014 , PDTB.EXTN_ATTRIBUTE_CHAR015 , PDTB.EXTN_ATTRIBUTE_CHAR016 , PDTB.EXTN_ATTRIBUTE_CHAR017 , PDTB.EXTN_ATTRIBUTE_CHAR018 , PDTB.EXTN_ATTRIBUTE_CHAR019 , PDTB.EXTN_ATTRIBUTE_CHAR020 , PDTB.EXTN_ATTRIBUTE_CHAR021 , PDTB.EXTN_ATTRIBUTE_CHAR022 , PDTB.EXTN_ATTRIBUTE_CHAR023 , PDTB.EXTN_ATTRIBUTE_CHAR024 , PDTB.EXTN_ATTRIBUTE_CHAR025 , PDTB.EXTN_ATTRIBUTE_CHAR026 , PDTB.EXTN_ATTRIBUTE_CHAR027 , PDTB.EXTN_ATTRIBUTE_CHAR028 , PDTB.EXTN_ATTRIBUTE_CHAR029, PDTB.EXTN_ATTRIBUTE_CHAR030 FROM PJE_DELIVERABLE_TYPES_B PDTB, PJE_DELIVERABLE_TYPES_TL PDTTL WHERE PDTB.DELIVERABLE_TYPE_ID = PDTTL.DELIVERABLE_TYPE_ID AND PDTB.ENTERPRISE_ID=PDTTL.ENTERPRISE_ID AND PDTTL.LANGUAGE = USERENV('LANG')