Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_UITEMPLS_FOR_PSNODES_V |
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'))