View: CS_SR_UWQ_NODES_VL

Product:	CS - Service
Description:	The base view for the form CSXNODES. This view shows all the user defined UWQ nodes for Service Request.
Implementation/DBA Data:	APPS.CS_SR_UWQ_NODES_VL

View Text

SELECT UWQ_B.ROWID ROW_ID
, UWQ_B.NODE_ID
, UWQ_TL.NODE_LABEL
, UWQ_B.NODE_VIEW
, UWQ_B.DATA_SOURCE
, UWQ_B.MEDIA_TYPE_ID
, UWQ_B.WHERE_CLAUSE
, UWQ_B.RES_CAT_ENUM_FLAG
, UWQ_B.NODE_TYPE
, UWQ_B.HIDE_IF_EMPTY
, UWQ_B.NODE_DEPTH
, UWQ_B.PARENT_ID
, UWQ_B.NODE_QUERY
, UWQ_B.CURSOR_SQL
, UWQ_B.CURSOR_KEY_COL
, UWQ_B.ENABLED_FLAG
, UWQ_B.CREATION_DATE
, UWQ_B.CREATED_BY
, UWQ_B.LAST_UPDATE_DATE
, UWQ_B.LAST_UPDATED_BY
, UWQ_B.LAST_UPDATE_LOGIN
, UWQ_B.OBJECT_VERSION_NUMBER
, UWQ_TL1.NODE_LABEL PARENT_LABEL
FROM CS_SR_UWQ_NODES_B UWQ_B
, CS_SR_UWQ_NODES_TL UWQ_TL
, CS_SR_UWQ_NODES_TL UWQ_TL1
WHERE UWQ_TL.NODE_ID = UWQ_B.NODE_ID
AND UWQ_TL.LANGUAGE = USERENV('LANG')
AND UWQ_TL1.NODE_ID(+) = UWQ_B.PARENT_ID
AND UWQ_TL.LANGUAGE(+) = USERENV('LANG')

Columns