VIEW: APPS.CZ_SESSIONITEM_BINDINFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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