VIEW: APPS.EDW_OPI_ACTV_ACTV_LCV

Source

View Text - Preformatted

SELECT 'ALL', ACTIVITY||'-'||I.INSTANCE_CODE||'-OPM', 'ACTV', ACTIVITY, ACTIVITY, ACTIVITY, ACTIVITY_DESC, COST_ANALYSIS_CODE, to_number(NULL), NULL,NULL,NULL,NULL,NULL, FA.LAST_UPDATE_DATE, FA.CREATION_DATE FROM FM_ACTV_MST FA ,EDW_LOCAL_INSTANCE I UNION SELECT 'ALL', CA.ACTIVITY_ID || '-' || INST.INSTANCE_CODE || '-OPI' ACTV_PK, 'ACTV' ACTV_DP, CA.ACTIVITY ACTV_CODE, CA.ACTIVITY NAME, CA.ACTIVITY ACTV_NAME, CA.DESCRIPTION DESCRIPTION, NULL COST_ANALYSIS_CODE, DECODE(CA.VALUE_ADDED_ACTIVITY_FLAG,'Yes',1,'No',0,to_number(NULL)) VALUE_ADDED, TO_CHAR(NULL) USER_ATTRIBUTE1, TO_CHAR(NULL) USER_ATTRIBUTE2, TO_CHAR(NULL) USER_ATTRIBUTE3, TO_CHAR(NULL) USER_ATTRIBUTE4, TO_CHAR(NULL) USER_ATTRIBUTE5, CA.LAST_UPDATE_DATE LAST_UPDATE_DATE, CA.CREATION_DATE CREATION_DATE FROM CST_ACTIVITIES CA, EDW_LOCAL_INSTANCE INST

View Text - HTML Formatted

SELECT 'ALL'
, ACTIVITY||'-'||I.INSTANCE_CODE||'-OPM'
, 'ACTV'
, ACTIVITY
, ACTIVITY
, ACTIVITY
, ACTIVITY_DESC
, COST_ANALYSIS_CODE
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, FA.LAST_UPDATE_DATE
, FA.CREATION_DATE
FROM FM_ACTV_MST FA
, EDW_LOCAL_INSTANCE I UNION SELECT 'ALL'
, CA.ACTIVITY_ID || '-' || INST.INSTANCE_CODE || '-OPI' ACTV_PK
, 'ACTV' ACTV_DP
, CA.ACTIVITY ACTV_CODE
, CA.ACTIVITY NAME
, CA.ACTIVITY ACTV_NAME
, CA.DESCRIPTION DESCRIPTION
, NULL COST_ANALYSIS_CODE
, DECODE(CA.VALUE_ADDED_ACTIVITY_FLAG
, 'YES'
, 1
, 'NO'
, 0
, TO_NUMBER(NULL)) VALUE_ADDED
, TO_CHAR(NULL) USER_ATTRIBUTE1
, TO_CHAR(NULL) USER_ATTRIBUTE2
, TO_CHAR(NULL) USER_ATTRIBUTE3
, TO_CHAR(NULL) USER_ATTRIBUTE4
, TO_CHAR(NULL) USER_ATTRIBUTE5
, CA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CA.CREATION_DATE CREATION_DATE
FROM CST_ACTIVITIES CA
, EDW_LOCAL_INSTANCE INST