Product: | IBC - Content Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBC_SUB_DIRECTORY_NODES_V |
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