VIEW: APPS.CZ_UITEMPLS_FOR_PSNODES_V

Source

View Text - Preformatted

SELECT c.ps_node_id, c.devl_project_id, c.NAME, c.parent_id, c.ps_node_type, c.feature_type, c.reference_id, c.counted_options_flag, c.tree_seq, c.product_flag, c.resource_flag, c.component_id, c.initial_num_value, c.initial_value, c.instantiable_flag, c.MAXIMUM, c.maximum_selected, c.MINIMUM, c.minimum_selected, c.virtual_flag, c.ui_omit, c.ui_section, c.component_sequence_path, c.from_populator_id, c.property_backptr, c.item_type_backptr, c.intl_text_id, c.item_id, c.orig_sys_ref, c.multi_config_flag, c.order_seq_flag, c.system_node_flag, c.bom_treatment, c.component_sequence_id, c.bom_required_flag, c.so_item_type_code, c.creation_date, c.last_update_date, c.deleted_flag, c.eff_from, c.eff_to, c.created_by, c.last_updated_by, c.security_mask, c.eff_mask, c.checkout_user, c.user_num01, c.user_num02, c.user_num03, c.user_num04, c.user_str01, c.user_str02, c.user_str03, c.user_str04, c.last_update_login, c.violation_text_id, c.effectivity_set_id, c.effective_from, c.effective_until, c.effective_usage_mask, c.decimal_qty_flag, c.persistent_node_id, c.quoteable_flag, c.primary_uom_code, c.bom_sort_order, c.ib_trackable, c.accumulator_flag, c.notes_text_id, c.displayname_capt_rule_id, c.src_application_id, c.max_text_length, c.displayname_text_id, c.sub_cons_id, c.max_length, c.ui_timestamp_add, c.ui_timestamp_remove, c.ui_timestamp_move, c.ui_timestamp_changetype, c.ui_timestamp_reorder, c.detailed_type_id, c.region_flag, c.parent_persistent_node_id, b.ui_def_id, (SELECT devl_project_id FROM CZ_UI_DEFS WHERE ui_def_id=b.ui_def_id) AS uidef_model_id, (SELECT NAME FROM CZ_UI_DEFS WHERE ui_def_id=b.ui_def_id) AS uidef_name, d.template_id, d.ui_def_id AS template_ui_def_id, d.template_name, d.jrad_doc, d.template_desc, d.template_type, d.root_element_signature_id, d.root_region_type, d.layout_ui_style, d.parent_container_type FROM CZ_UIDEF_SIGNATURE_TEMPLS_V b, CZ_UI_TYPEDPSN_V c, CZ_UI_TEMPLATES d WHERE (EXISTS(SELECT NULL FROM CZ_UI_DEFS u1 WHERE u1.ui_def_id=b.ui_def_id AND u1.ui_style='5' AND u1.deleted_flag='0') OR EXISTS(SELECT NULL FROM CZ_UI_DEFS u1 WHERE u1.ui_def_id=b.ui_def_id AND u1.ui_style='7' AND u1.devl_project_id=c.devl_project_id AND u1.deleted_flag='0')) AND c.detailed_type_id=b.signature_id AND b.template_id=d.template_id AND b.template_ui_def_id=d.ui_def_id AND d.deleted_flag='0' UNION ALL SELECT c.ps_node_id, c.devl_project_id, c.NAME, c.parent_id, c.ps_node_type, c.feature_type, c.reference_id, c.counted_options_flag, c.tree_seq, c.product_flag, c.resource_flag, c.component_id, c.initial_num_value, c.initial_value, c.instantiable_flag, c.MAXIMUM, c.maximum_selected, c.MINIMUM, c.minimum_selected, c.virtual_flag, c.ui_omit, c.ui_section, c.component_sequence_path, c.from_populator_id, c.property_backptr, c.item_type_backptr, c.intl_text_id, c.item_id, c.orig_sys_ref, c.multi_config_flag, c.order_seq_flag, c.system_node_flag, c.bom_treatment, c.component_sequence_id, c.bom_required_flag, c.so_item_type_code, c.creation_date, c.last_update_date, c.deleted_flag, c.eff_from, c.eff_to, c.created_by, c.last_updated_by, c.security_mask, c.eff_mask, c.checkout_user, c.user_num01, c.user_num02, c.user_num03, c.user_num04, c.user_str01, c.user_str02, c.user_str03, c.user_str04, c.last_update_login, c.violation_text_id, c.effectivity_set_id, c.effective_from, c.effective_until, c.effective_usage_mask, c.decimal_qty_flag, c.persistent_node_id, c.quoteable_flag, c.primary_uom_code, c.bom_sort_order, c.ib_trackable, c.accumulator_flag, c.notes_text_id, c.displayname_capt_rule_id, c.src_application_id, c.max_text_length, c.displayname_text_id, c.sub_cons_id, c.max_length, c.ui_timestamp_add, c.ui_timestamp_remove, c.ui_timestamp_move, c.ui_timestamp_changetype, c.ui_timestamp_reorder, c.detailed_type_id, c.region_flag, c.parent_persistent_node_id, u.ui_def_id, u.devl_project_id AS uidef_model_id, u.NAME AS uidef_name, NULL AS template_id, NULL AS template_ui_def_id, NULL AS template_name, NULL AS jrad_doc, NULL AS template_desc, NULL AS template_type, NULL AS root_element_signature_id, NULL AS root_region_type, NULL AS layout_ui_style, NULL AS parent_container_type FROM CZ_UI_DEFS u, CZ_UI_TYPEDPSN_V c WHERE (u.ui_style='5' OR (u.devl_project_id=c.devl_project_id AND ui_style='7')) AND NOT EXISTS(SELECT NULL FROM CZ_UI_CONT_TYPE_TEMPLS d WHERE d.ui_def_id=u.ui_def_id AND d.deleted_flag='0' AND d.content_type IN(SELECT e.subject_type FROM CZ_TYPE_RELATIONSHIPS e WHERE e.object_type=c.detailed_type_id AND e.rel_type_code='CNV' AND deleted_flag='0'))

View Text - HTML Formatted

SELECT C.PS_NODE_ID
, C.DEVL_PROJECT_ID
, C.NAME
, C.PARENT_ID
, C.PS_NODE_TYPE
, C.FEATURE_TYPE
, C.REFERENCE_ID
, C.COUNTED_OPTIONS_FLAG
, C.TREE_SEQ
, C.PRODUCT_FLAG
, C.RESOURCE_FLAG
, C.COMPONENT_ID
, C.INITIAL_NUM_VALUE
, C.INITIAL_VALUE
, C.INSTANTIABLE_FLAG
, C.MAXIMUM
, C.MAXIMUM_SELECTED
, C.MINIMUM
, C.MINIMUM_SELECTED
, C.VIRTUAL_FLAG
, C.UI_OMIT
, C.UI_SECTION
, C.COMPONENT_SEQUENCE_PATH
, C.FROM_POPULATOR_ID
, C.PROPERTY_BACKPTR
, C.ITEM_TYPE_BACKPTR
, C.INTL_TEXT_ID
, C.ITEM_ID
, C.ORIG_SYS_REF
, C.MULTI_CONFIG_FLAG
, C.ORDER_SEQ_FLAG
, C.SYSTEM_NODE_FLAG
, C.BOM_TREATMENT
, C.COMPONENT_SEQUENCE_ID
, C.BOM_REQUIRED_FLAG
, C.SO_ITEM_TYPE_CODE
, C.CREATION_DATE
, C.LAST_UPDATE_DATE
, C.DELETED_FLAG
, C.EFF_FROM
, C.EFF_TO
, C.CREATED_BY
, C.LAST_UPDATED_BY
, C.SECURITY_MASK
, C.EFF_MASK
, C.CHECKOUT_USER
, C.USER_NUM01
, C.USER_NUM02
, C.USER_NUM03
, C.USER_NUM04
, C.USER_STR01
, C.USER_STR02
, C.USER_STR03
, C.USER_STR04
, C.LAST_UPDATE_LOGIN
, C.VIOLATION_TEXT_ID
, C.EFFECTIVITY_SET_ID
, C.EFFECTIVE_FROM
, C.EFFECTIVE_UNTIL
, C.EFFECTIVE_USAGE_MASK
, C.DECIMAL_QTY_FLAG
, C.PERSISTENT_NODE_ID
, C.QUOTEABLE_FLAG
, C.PRIMARY_UOM_CODE
, C.BOM_SORT_ORDER
, C.IB_TRACKABLE
, C.ACCUMULATOR_FLAG
, C.NOTES_TEXT_ID
, C.DISPLAYNAME_CAPT_RULE_ID
, C.SRC_APPLICATION_ID
, C.MAX_TEXT_LENGTH
, C.DISPLAYNAME_TEXT_ID
, C.SUB_CONS_ID
, C.MAX_LENGTH
, C.UI_TIMESTAMP_ADD
, C.UI_TIMESTAMP_REMOVE
, C.UI_TIMESTAMP_MOVE
, C.UI_TIMESTAMP_CHANGETYPE
, C.UI_TIMESTAMP_REORDER
, C.DETAILED_TYPE_ID
, C.REGION_FLAG
, C.PARENT_PERSISTENT_NODE_ID
, B.UI_DEF_ID
, (SELECT DEVL_PROJECT_ID
FROM CZ_UI_DEFS
WHERE UI_DEF_ID=B.UI_DEF_ID) AS UIDEF_MODEL_ID
, (SELECT NAME
FROM CZ_UI_DEFS
WHERE UI_DEF_ID=B.UI_DEF_ID) AS UIDEF_NAME
, D.TEMPLATE_ID
, D.UI_DEF_ID AS TEMPLATE_UI_DEF_ID
, D.TEMPLATE_NAME
, D.JRAD_DOC
, D.TEMPLATE_DESC
, D.TEMPLATE_TYPE
, D.ROOT_ELEMENT_SIGNATURE_ID
, D.ROOT_REGION_TYPE
, D.LAYOUT_UI_STYLE
, D.PARENT_CONTAINER_TYPE
FROM CZ_UIDEF_SIGNATURE_TEMPLS_V B
, CZ_UI_TYPEDPSN_V C
, CZ_UI_TEMPLATES D
WHERE (EXISTS(SELECT NULL
FROM CZ_UI_DEFS U1
WHERE U1.UI_DEF_ID=B.UI_DEF_ID
AND U1.UI_STYLE='5'
AND U1.DELETED_FLAG='0') OR EXISTS(SELECT NULL
FROM CZ_UI_DEFS U1
WHERE U1.UI_DEF_ID=B.UI_DEF_ID
AND U1.UI_STYLE='7'
AND U1.DEVL_PROJECT_ID=C.DEVL_PROJECT_ID
AND U1.DELETED_FLAG='0'))
AND C.DETAILED_TYPE_ID=B.SIGNATURE_ID
AND B.TEMPLATE_ID=D.TEMPLATE_ID
AND B.TEMPLATE_UI_DEF_ID=D.UI_DEF_ID
AND D.DELETED_FLAG='0' UNION ALL SELECT C.PS_NODE_ID
, C.DEVL_PROJECT_ID
, C.NAME
, C.PARENT_ID
, C.PS_NODE_TYPE
, C.FEATURE_TYPE
, C.REFERENCE_ID
, C.COUNTED_OPTIONS_FLAG
, C.TREE_SEQ
, C.PRODUCT_FLAG
, C.RESOURCE_FLAG
, C.COMPONENT_ID
, C.INITIAL_NUM_VALUE
, C.INITIAL_VALUE
, C.INSTANTIABLE_FLAG
, C.MAXIMUM
, C.MAXIMUM_SELECTED
, C.MINIMUM
, C.MINIMUM_SELECTED
, C.VIRTUAL_FLAG
, C.UI_OMIT
, C.UI_SECTION
, C.COMPONENT_SEQUENCE_PATH
, C.FROM_POPULATOR_ID
, C.PROPERTY_BACKPTR
, C.ITEM_TYPE_BACKPTR
, C.INTL_TEXT_ID
, C.ITEM_ID
, C.ORIG_SYS_REF
, C.MULTI_CONFIG_FLAG
, C.ORDER_SEQ_FLAG
, C.SYSTEM_NODE_FLAG
, C.BOM_TREATMENT
, C.COMPONENT_SEQUENCE_ID
, C.BOM_REQUIRED_FLAG
, C.SO_ITEM_TYPE_CODE
, C.CREATION_DATE
, C.LAST_UPDATE_DATE
, C.DELETED_FLAG
, C.EFF_FROM
, C.EFF_TO
, C.CREATED_BY
, C.LAST_UPDATED_BY
, C.SECURITY_MASK
, C.EFF_MASK
, C.CHECKOUT_USER
, C.USER_NUM01
, C.USER_NUM02
, C.USER_NUM03
, C.USER_NUM04
, C.USER_STR01
, C.USER_STR02
, C.USER_STR03
, C.USER_STR04
, C.LAST_UPDATE_LOGIN
, C.VIOLATION_TEXT_ID
, C.EFFECTIVITY_SET_ID
, C.EFFECTIVE_FROM
, C.EFFECTIVE_UNTIL
, C.EFFECTIVE_USAGE_MASK
, C.DECIMAL_QTY_FLAG
, C.PERSISTENT_NODE_ID
, C.QUOTEABLE_FLAG
, C.PRIMARY_UOM_CODE
, C.BOM_SORT_ORDER
, C.IB_TRACKABLE
, C.ACCUMULATOR_FLAG
, C.NOTES_TEXT_ID
, C.DISPLAYNAME_CAPT_RULE_ID
, C.SRC_APPLICATION_ID
, C.MAX_TEXT_LENGTH
, C.DISPLAYNAME_TEXT_ID
, C.SUB_CONS_ID
, C.MAX_LENGTH
, C.UI_TIMESTAMP_ADD
, C.UI_TIMESTAMP_REMOVE
, C.UI_TIMESTAMP_MOVE
, C.UI_TIMESTAMP_CHANGETYPE
, C.UI_TIMESTAMP_REORDER
, C.DETAILED_TYPE_ID
, C.REGION_FLAG
, C.PARENT_PERSISTENT_NODE_ID
, U.UI_DEF_ID
, U.DEVL_PROJECT_ID AS UIDEF_MODEL_ID
, U.NAME AS UIDEF_NAME
, NULL AS TEMPLATE_ID
, NULL AS TEMPLATE_UI_DEF_ID
, NULL AS TEMPLATE_NAME
, NULL AS JRAD_DOC
, NULL AS TEMPLATE_DESC
, NULL AS TEMPLATE_TYPE
, NULL AS ROOT_ELEMENT_SIGNATURE_ID
, NULL AS ROOT_REGION_TYPE
, NULL AS LAYOUT_UI_STYLE
, NULL AS PARENT_CONTAINER_TYPE
FROM CZ_UI_DEFS U
, CZ_UI_TYPEDPSN_V C
WHERE (U.UI_STYLE='5' OR (U.DEVL_PROJECT_ID=C.DEVL_PROJECT_ID
AND UI_STYLE='7'))
AND NOT EXISTS(SELECT NULL
FROM CZ_UI_CONT_TYPE_TEMPLS D
WHERE D.UI_DEF_ID=U.UI_DEF_ID
AND D.DELETED_FLAG='0'
AND D.CONTENT_TYPE IN(SELECT E.SUBJECT_TYPE
FROM CZ_TYPE_RELATIONSHIPS E
WHERE E.OBJECT_TYPE=C.DETAILED_TYPE_ID
AND E.REL_TYPE_CODE='CNV'
AND DELETED_FLAG='0'))