View: IBC_SUB_DIRECTORY_NODES_V

Product:	IBC - Content Manager
Description:
Implementation/DBA Data:	APPS.IBC_SUB_DIRECTORY_NODES_V

View Text

SELECT REL.DIRECTORY_NODE_REL_ID
, REL.PARENT_DIR_NODE_ID
, REL.CHILD_DIR_NODE_ID
, SUB_DIR.DIRECTORY_NODE_CODE
, SUB_DIR.NODE_TYPE
, SUB_DIR.CREATED_BY
, SUB_DIR.CREATION_DATE
, SUB_DIR.LAST_UPDATED_BY
, SUB_DIR.LAST_UPDATE_DATE
, SUB_DIR.LAST_UPDATE_LOGIN
, SUB_DIR.OBJECT_VERSION_NUMBER
, SUB_DIR.SECURITY_GROUP_ID
, SUB_DIR.DIRECTORY_NODE_NAME
, SUB_DIR.DESCRIPTION
FROM IBC_DIRECTORY_NODES_VL SUB_DIR
, IBC_DIRECTORY_NODE_RELS REL
WHERE SUB_DIR.DIRECTORY_NODE_ID = REL.CHILD_DIR_NODE_ID

Columns