VIEW: APPS.CS_SR_UWQ_NODES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')