PJF_PROJECTS_COA_ALL_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

PROJECT_NUMBER PROJECT_NUMBER_1 PROJECT_NUMBER_2 PROJECT_NUMBER_3 PROJECT_NUMBER_4 PROJECT_NUMBER_5 PROJECT_NUMBER_6 PROJECT_NUMBER_7 PROJECT_NUMBER_8 PROJECT_NUMBER_9 PROJECT_NUMBER_10 PROJECT_NAME START_DATE COMPLETION_DATE CLOSED_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 SUMMARY_FLAG FLEX_VALUE_ATTRIBUTE1 FLEX_VALUE_ATTRIBUTE2 FLEX_VALUE_ATTRIBUTE3 FLEX_VALUE_ATTRIBUTE4 FLEX_VALUE_ATTRIBUTE5 FLEX_VALUE_ATTRIBUTE6 FLEX_VALUE_ATTRIBUTE7 FLEX_VALUE_ATTRIBUTE8 FLEX_VALUE_ATTRIBUTE9 FLEX_VALUE_ATTRIBUTE10 FLEX_VALUE_ATTRIBUTE11 FLEX_VALUE_ATTRIBUTE12 FLEX_VALUE_ATTRIBUTE13 FLEX_VALUE_ATTRIBUTE14 FLEX_VALUE_ATTRIBUTE15 FLEX_VALUE_ATTRIBUTE16 FLEX_VALUE_ATTRIBUTE17 FLEX_VALUE_ATTRIBUTE18 FLEX_VALUE_ATTRIBUTE19 FLEX_VALUE_ATTRIBUTE20 CREATION_DATE LAST_UPDATE_DATE

Query

SQL_Statement

SELECT CAST(REVERSE( SUBSTR(REVERSE(B.SEGMENT1),1,25)) AS VARCHAR2(25)) PROJECT_NUMBER, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1))) AS VARCHAR2(25)) PROJECT_NUMBER_1, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-1)) AS VARCHAR2(25)) PROJECT_NUMBER_2, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-2)) AS VARCHAR2(25)) PROJECT_NUMBER_3, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-3)) AS VARCHAR2(25)) PROJECT_NUMBER_4, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-4)) AS VARCHAR2(25)) PROJECT_NUMBER_5, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-5)) AS VARCHAR2(25)) PROJECT_NUMBER_6, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-6)) AS VARCHAR2(25)) PROJECT_NUMBER_7, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-7)) AS VARCHAR2(25)) PROJECT_NUMBER_8, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-8)) AS VARCHAR2(25)) PROJECT_NUMBER_9, CAST(SUBSTR('0000000000' ||B.SEGMENT1, (LENGTH('0000000000' ||B.SEGMENT1)-9)) AS VARCHAR2(25)) PROJECT_NUMBER_10, CAST(T.NAME AS VARCHAR2(240)) PROJECT_NAME, B.START_DATE START_DATE, B.COMPLETION_DATE COMPLETION_DATE, B.CLOSED_DATE CLOSED_DATE, CAST(B.ATTRIBUTE_CATEGORY AS VARCHAR2(30)) ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE6 ATTRIBUTE6, B.ATTRIBUTE7 ATTRIBUTE7, B.ATTRIBUTE8 ATTRIBUTE8, B.ATTRIBUTE9 ATTRIBUTE9, B.ATTRIBUTE10 ATTRIBUTE10, CAST('N' AS VARCHAR2(30)) SUMMARY_FLAG, CAST('Y' AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE1, CAST('Y' AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE2, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE3, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE4, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE5, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE6, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE7, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE8, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE9, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE10, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE11, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE12, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE13, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE14, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE15, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE16, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE17, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE18, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE19, CAST( NULL AS VARCHAR2(30)) FLEX_VALUE_ATTRIBUTE20, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM PJF_PROJECTS_ALL_B B, PJF_PROJECTS_ALL_TL T WHERE T.PROJECT_ID = B.PROJECT_ID AND LANGUAGE = USERENV('LANG') AND B.TEMPLATE_FLAG = 'N' UNION select '0', '0', '00', '000', '0000', '00000', '000000', '0000000', '00000000', '000000000', '0000000000', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'N', 'Y', 'Y', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, TO_DATE('01/01/1950', 'DD/MM/YYYY'), TO_DATE('01/01/1950', 'DD/MM/YYYY') from dual WHERE NOT EXISTS (SELECT 1 FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1 = '0')