View: JTF_NAV_NODE_TYPES_V

Product:	JTF - CRM Foundation
Description:	View on the base table.
Implementation/DBA Data:	APPS.JTF_NAV_NODE_TYPES_V

View Text

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

Columns