PJF_EPS_HIERARCHIES_PRJ_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
NODE_ID NODE_TYPE_CODE PARENT_NODE_ID PROJECT_ID PROJECT_COUNT REP_CURRENCY_CODE REP_CURRENCY_RATE_TYPE STRUCTURE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT NODE_ID, NODE_TYPE_CODE, PARENT_NODE_ID, PROJECT_ID, PROJECT_COUNT, REP_CURRENCY_CODE, REP_CURRENCY_RATE_TYPE, STRUCTURE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER FROM PJF_EPS_HIERARCHIES WHERE PJF_EPS_HIERARCHIES.NODE_TYPE_CODE='P'