PJS_PROGRAM_DEFN_VL

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name

PROGRAM_ID PARENT_PROGRAM_ID TREE_STRUCTURE_ID PROGRAM_LEVEL PROGRAM_NUMBER PROGRAM_NAME PROGRAM_DESC PROGRAM_OBJECTIVE PROGRAM_STATUS_CODE PROGRAM_SYSTEM_STATUS_CODE OWNING_ORGANIZATION_ID LOB_CODE STRATEGY_CODE START_DATE END_DATE ASSESSMENT_CODE PRIORITY_CODE OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REGION_CODE PUBLIC_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ADDL_ATTR_CHAR1 ADDL_ATTR_CHAR2 ADDL_ATTR_CHAR3 ADDL_ATTR_CHAR4 ADDL_ATTR_CHAR5 ADDL_ATTR_CHAR6 ADDL_ATTR_CHAR7 ADDL_ATTR_CHAR8 ADDL_ATTR_CHAR9 ADDL_ATTR_CHAR10 PROGRAM_BUDGET PROGRAM_BUDGET_CURRENCY

Query

SQL_Statement

SELECT base.PROGRAM_ID , base.PARENT_PROGRAM_ID , base.TREE_STRUCTURE_ID , base.PROGRAM_LEVEL , base.PROGRAM_NUMBER , trans.PROGRAM_NAME , trans.PROGRAM_DESC , trans.PROGRAM_OBJECTIVE , base.PROGRAM_STATUS_CODE , base.PROGRAM_SYSTEM_STATUS_CODE , base.OWNING_ORGANIZATION_ID , base.LOB_CODE , base.STRATEGY_CODE , base.START_DATE , base.END_DATE , base.ASSESSMENT_CODE , base.PRIORITY_CODE , base.OBJECT_VERSION_NUMBER , base.LAST_UPDATE_DATE , base.LAST_UPDATED_BY , base.CREATION_DATE , base.CREATED_BY , base.LAST_UPDATE_LOGIN , base.REGION_CODE , base.PUBLIC_FLAG , base.ATTRIBUTE_CATEGORY , base.ATTRIBUTE1 , base.ATTRIBUTE2 , base.ATTRIBUTE3 , base.ATTRIBUTE4 , base.ATTRIBUTE5 , base.ATTRIBUTE6 , base.ATTRIBUTE7 , base.ATTRIBUTE8 , base.ATTRIBUTE9 , base.ATTRIBUTE10 , base.ADDL_ATTR_CHAR1 , base.ADDL_ATTR_CHAR2 , base.ADDL_ATTR_CHAR3 , base.ADDL_ATTR_CHAR4 , base.ADDL_ATTR_CHAR5 , base.ADDL_ATTR_CHAR6 , base.ADDL_ATTR_CHAR7 , base.ADDL_ATTR_CHAR8 , base.ADDL_ATTR_CHAR9 , base.ADDL_ATTR_CHAR10 , base.PROGRAM_BUDGET , base.PROGRAM_BUDGET_CURRENCY FROM PJS_PROGRAM_DEFN_B base , PJS_PROGRAM_DEFN_TL trans WHERE base.PROGRAM_ID = trans.PROGRAM_ID AND trans.LANGUAGE = USERENV('LANG')