View: CZ_SESSIONITEM_BINDINFO_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_SESSIONITEM_BINDINFO_V

View Text

SELECT TPLMSG.MESSAGE_TYPE
, SESLKV.VALUE_LABEL AS REGION_TYPE_LABEL
, TPLMSG.TEMPLATE_TYPE AS SESSION_ITEM_TYPE
, TPLSIG.COLLECTION_FLAG
, TPLMSG.PARENT_CONTAINER_TYPE AS PARENT_SESSION_ITEM
, TPLMSG.TEMPLATE_NAME AS SESSION_ITEM_NAME
, JRAD_DOC AS SESSION_ITEM_ATTRIBUTE_SET
, UIDEF.UI_DEF_ID AS P_UI_DEF_ID
FROM CZ_RTINFO_TEMPLTYPES_LKV SESLKV
, CZ_UI_TEMPLATES TPLMSG
, CZ_SIGNATURES TPLSIG
, CZ_UI_DEFS UIDEF
WHERE TPLSIG.SIGNATURE_ID = TPLMSG.TEMPLATE_TYPE
AND TPLSIG.DELETED_FLAG = '0'
AND SESLKV.NUMERIC_ID_VALUE = TPLMSG.MESSAGE_TYPE
AND TPLMSG.UI_DEF_ID = 0
AND UIDEF.UI_DEF_ID = 0 UNION SELECT TPLMSG.MESSAGE_TYPE
, SESLKV.VALUE_LABEL AS REGION_TYPE_LABEL
, TPLMSG.TEMPLATE_TYPE AS SESSION_ITEM_TYPE
, TPLSIG.COLLECTION_FLAG
, TPLMSG.PARENT_CONTAINER_TYPE AS PARENT_SESSION_ITEM
, TPLMSG.TEMPLATE_NAME AS SESSION_ITEM_NAME
, JRAD_DOC AS SESSION_ITEM_ATTRIBUTE_SET
, UIDEF.UI_DEF_ID AS P_UI_DEF_ID
FROM CZ_RTINFO_TEMPLTYPES_LKV SESLKV
, CZ_UI_TEMPLATES TPLMSG
, CZ_SIGNATURES TPLSIG
, CZ_DEVL_PROJECTS PRJ
, CZ_UI_DEFS UIDEF
WHERE TPLSIG.SIGNATURE_ID = TPLMSG.TEMPLATE_TYPE
AND TPLSIG.DELETED_FLAG = '0'
AND SESLKV.NUMERIC_ID_VALUE = TPLMSG.MESSAGE_TYPE
AND TPLMSG.UI_DEF_ID = 0
AND UIDEF.UI_DEF_ID>0
AND UIDEF.DEVL_PROJECT_ID=PRJ.DEVL_PROJECT_ID
AND ( (NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'F')
AND NVL(TPLSIG.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'F')) OR (NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'L')
AND NVL(TPLSIG.CONFIG_ENGINE_TYPE
, 'L') IN('B'
, 'L')) )

Columns