PJF_EPS_NODES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
NAME DESCRIPTION NODE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER FULL_NODE_NAME

Query

SQL_Statement

SELECT PJF_EPS_NODES_TL.NAME, PJF_EPS_NODES_TL.DESCRIPTION, PJF_EPS_NODES_B.NODE_ID, PJF_EPS_NODES_B.LAST_UPDATE_DATE, PJF_EPS_NODES_B.LAST_UPDATED_BY, PJF_EPS_NODES_B.CREATION_DATE, PJF_EPS_NODES_B.CREATED_BY, PJF_EPS_NODES_B.LAST_UPDATE_LOGIN, PJF_EPS_NODES_B.OBJECT_VERSION_NUMBER, PJF_EPS_NODES_B.FULL_NODE_NAME FROM PJF_EPS_NODES_TL PJF_EPS_NODES_TL, PJF_EPS_NODES_B PJF_EPS_NODES_B WHERE PJF_EPS_NODES_TL.NODE_ID = PJF_EPS_NODES_B.NODE_ID AND PJF_EPS_NODES_TL.LANGUAGE = USERENV('LANG')