Product: | JTF - CRM Foundation |
---|---|
Description: | View on the base table. |
Implementation/DBA Data: | APPS.JTF_NAV_NODE_TYPES_V |
SELECT NT.NODE_TYPE_ID
, TR.ROOT_VALUE ROOT_KEY
, NT.NODE_TYPE
, NT.TREE_ROOT_ID
, NT.AK_FLOW_NAME
, NT.AK_PARENT_PAGE_NAME
, NT.AK_PK_NAME
, NT.AK_WHERE_CLAUSE
, NT.AK_WHERE_BINDS
, NT.ICON_NAME
, NT.FORM_NAME
, NT.FORM_PARAM_LIST
, NT.STATIC_CHILD_FLAG
, NT.CREATED_BY
, NT.CREATION_DATE
, NT.LAST_UPDATE_LOGIN
, NT.LAST_UPDATE_DATE
, NT.LAST_UPDATED_BY
FROM JTF_NAV_NODE_TYPES NT
, JTF_NAV_TREE_ROOTS_VL TR
WHERE NT.TREE_ROOT_ID = TR.TREE_ROOT_ID