View: CZ_REPOSITORY_MAIN_HGRID_V

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

View Text

SELECT CZRPENTRIESEO.OBJECT_TYPE
, CZRPENTRIESEO.OBJECT_ID
, CZRPENTRIESEO.ENCLOSING_FOLDER
, CZRPENTRIESEO.NAME
, DECODE(CZRPENTRIESEO.OBJECT_TYPE
, 'USG'
, CZ_DEVELOPER_UTILS_PVT.GET_TRANS_DESC(CZRPENTRIESEO.OBJECT_ID
, 'USG')
, CZRPENTRIESEO.DESCRIPTION)
, CZRPENTRIESEO.NOTES
, CZRPENTRIESEO.DELETED_FLAG
, CZRPENTRIESEO.CREATED_BY
, CZRPENTRIESEO.CREATION_DATE
, CZRPENTRIESEO.LAST_UPDATED_BY
, CZRPENTRIESEO.LAST_UPDATE_DATE
, CZRPENTRIESEO.SEEDED_FLAG
, 'T' AS HAS_ENTITY_PRIV
, DECODE (CZDEVLPROJECTS.CHECKOUT_USER
, NULL
, '0'
, FND_GLOBAL.USER_NAME
, '1'
, '2' ) AS USER_LOCK_STATUS
, 'T' AS IS_MODEL_EDITABLE
, CZDEVLPROJECTS.CHECKOUT_USER
, CZDEVLPROJECTS.PRODUCT_KEY
, CZDEVLPROJECTS.ORGANIZATION_ID
, CZDEVLPROJECTS.INVENTORY_ITEM_ID
, CZDEVLPROJECTS.MODEL_TYPE
, CZ_DEVELOPER_UTILS_PVT.GET_REPOSITORY_PATH (OBJECT_ID
, OBJECT_TYPE ) AS PATH
, CZDEVLPROJECTS.ORIG_SYS_REF
, CZDEVLPROJECTS.LAST_UPDATE_DATE AS MODEL_LAST_UPDATE_DATE
, CZDEVLPROJECTS.LAST_UPDATED_BY AS MODEL_LAST_UPDATED_BY
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.DATA_VALUE AS DETAILED_OBJECT_TYPE
, TO_NUMBER (NULL) AS PROPERTY_DATA_TYPE
, NULL AS PROPERTY_DEF_VALUE
, TO_NUMBER (NULL) AS PROPERTY_DEF_NUM_VALUE
, NULL AS PROPERTY_DEF_LOCAL_TEXT
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CZ_YES_NO_TYPE'
AND LOOKUP_CODE = DECODE (CZDEVLPROJECTS.CHECKOUT_USER
, NULL
, 'N'
, 'Y')
AND CZRPENTRIESEO.OBJECT_TYPE = 'PRJ') AS LOCK_STATUS
, CZDEVLPROJECTS.CHECKOUT_TIME
, (SELECT A.REF_PART_NBR
FROM CZ_ITEM_MASTERS A
, CZ_PS_NODES B
WHERE CZRPENTRIESEO.OBJECT_TYPE = 'PRJ'
AND B.PS_NODE_ID = CZRPENTRIESEO.OBJECT_ID
AND B.ITEM_ID = A.ITEM_ID (+)) AS REF_PART_NBR
, CZ_EFFECTIVITY_SETS.EFFECTIVE_FROM AS EFFECTIVE_FROM
, CZ_EFFECTIVITY_SETS.EFFECTIVE_UNTIL AS EFFECTIVE_UNTIL
, NVL(CZDEVLPROJECTS.CONFIG_ENGINE_TYPE
, 'L') AS CONFIG_ENGINE_TYPE
FROM CZ_RP_ENTRIES CZRPENTRIESEO
, (SELECT 'PRJ' AS PROJECT_TYPE
, INNERPRJ.DEVL_PROJECT_ID
, INNERPRJ.CHECKOUT_USER
, INNERPRJ.PRODUCT_KEY
, INNERPRJ.ORGANIZATION_ID
, INNERPRJ.INVENTORY_ITEM_ID
, INNERPRJ.MODEL_TYPE
, INNERPRJ.DELETED_FLAG
, INNERPRJ.ORIG_SYS_REF
, INNERPRJ.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, INNERPRJ.LAST_UPDATED_BY
, INNERPRJ.CHECKOUT_TIME
, INNERPRJ.CONFIG_ENGINE_TYPE
FROM CZ_DEVL_PROJECTS INNERPRJ) CZDEVLPROJECTS
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
, CZ_EFFECTIVITY_SETS
WHERE CZRPENTRIESEO.DELETED_FLAG = '0'
AND CZRPENTRIESEO.OBJECT_TYPE NOT IN ('PRP'
, 'UCT')
AND CZRPENTRIESEO.OBJECT_TYPE = CZDEVLPROJECTS.PROJECT_TYPE(+)
AND CZRPENTRIESEO.OBJECT_ID = CZDEVLPROJECTS.DEVL_PROJECT_ID(+)
AND CZRPENTRIESEO.DELETED_FLAG = CZDEVLPROJECTS.DELETED_FLAG(+)
AND CZRPENTRIESEO.OBJECT_ID = CZ_EFFECTIVITY_SETS.EFFECTIVITY_SET_ID(+)
AND DECODE (CZDEVLPROJECTS.INVENTORY_ITEM_ID
, NULL
, CZRPENTRIESEO.OBJECT_TYPE
, 'BOM' ) = CZ_RPOBJECTTYPES_LKV.DATA_VALUE
AND ( CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE IS NOT NULL
AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1' )
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0 UNION ALL SELECT CZRPENTRIESEO.OBJECT_TYPE
, CZRPENTRIESEO.OBJECT_ID
, CZRPENTRIESEO.ENCLOSING_FOLDER
, CZRPENTRIESEO.NAME
, CZRPENTRIESEO.DESCRIPTION
, CZRPENTRIESEO.NOTES
, CZRPENTRIESEO.DELETED_FLAG
, CZRPENTRIESEO.CREATED_BY
, CZRPENTRIESEO.CREATION_DATE
, CZRPENTRIESEO.LAST_UPDATED_BY
, CZRPENTRIESEO.LAST_UPDATE_DATE
, CZRPENTRIESEO.SEEDED_FLAG
, 'T' AS HAS_ENTITY_PRIV
, '0' AS USER_LOCK_STATUS
, 'T' AS IS_MODEL_EDITABLE
, CZPROPERTIES.CHECKOUT_USER
, NULL AS PRODUCT_KEY
, TO_NUMBER (NULL) AS ORGANIZATION_ID
, TO_NUMBER (NULL) AS INVENTORY_ITEM_ID
, NULL AS MODEL_TYPE
, CZ_DEVELOPER_UTILS_PVT.GET_REPOSITORY_PATH (OBJECT_ID
, OBJECT_TYPE ) AS PATH
, NULL AS ORIG_SYS_REF
, TO_DATE (NULL) AS MODEL_LAST_UPDATE_DATE
, TO_NUMBER (NULL) AS MODEL_LAST_UPDATED_BY
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.DATA_VALUE AS DETAILED_OBJECT_TYPE
, CZPROPERTIES.DATA_TYPE AS PROPERTY_DATA_TYPE
, CZPROPERTIES.DEF_VALUE AS PROPERTY_DEF_VALUE
, CZPROPERTIES.DEF_NUM_VALUE AS PROPERTY_DEF_NUM_VALUE
, NULL AS PROPERTY_DEF_LOCAL_TEXT
, NULL AS LOCK_STATUS
, TO_DATE (NULL) AS CHECKOUT_TIME
, NULL AS REF_PART_NBR
, NULL AS EFFECTIVE_FROM
, NULL AS EFFECTIVE_UNTIL
, NULL AS CONFIG_ENGINE_TYPE
FROM CZ_RP_ENTRIES CZRPENTRIESEO
, (SELECT 'PRP' AS PROJECT_TYPE
, INNERPRP.PROPERTY_ID
, INNERPRP.DATA_TYPE
, INNERPRP.DEF_VALUE
, INNERPRP.DELETED_FLAG
, INNERPRP.LAST_UPDATED_BY
, INNERPRP.CHECKOUT_USER
, INNERPRP.LAST_UPDATE_DATE
, INNERPRP.DEF_NUM_VALUE
FROM CZ_PROPERTIES INNERPRP
WHERE INNERPRP.DELETED_FLAG = '0'
AND INNERPRP.DATA_TYPE <> 8) CZPROPERTIES
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZRPENTRIESEO.DELETED_FLAG = '0'
AND CZRPENTRIESEO.OBJECT_TYPE = CZPROPERTIES.PROJECT_TYPE
AND CZRPENTRIESEO.OBJECT_ID = CZPROPERTIES.PROPERTY_ID
AND CZRPENTRIESEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE
AND ( CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1' )
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0 UNION ALL SELECT CZRPENTRIESEO.OBJECT_TYPE
, CZRPENTRIESEO.OBJECT_ID
, CZRPENTRIESEO.ENCLOSING_FOLDER
, CZRPENTRIESEO.NAME
, CZRPENTRIESEO.DESCRIPTION
, CZRPENTRIESEO.NOTES
, CZRPENTRIESEO.DELETED_FLAG
, CZRPENTRIESEO.CREATED_BY
, CZRPENTRIESEO.CREATION_DATE
, CZRPENTRIESEO.LAST_UPDATED_BY
, CZRPENTRIESEO.LAST_UPDATE_DATE
, CZRPENTRIESEO.SEEDED_FLAG
, 'T' AS HAS_ENTITY_PRIV
, '0' AS USER_LOCK_STATUS
, 'T' AS IS_MODEL_EDITABLE
, CZTEXTPROPERTIES.CHECKOUT_USER
, NULL AS PRODUCT_KEY
, TO_NUMBER (NULL) AS ORGANIZATION_ID
, TO_NUMBER (NULL) AS INVENTORY_ITEM_ID
, NULL AS MODEL_TYPE
, CZ_DEVELOPER_UTILS_PVT.GET_REPOSITORY_PATH (OBJECT_ID
, OBJECT_TYPE ) AS PATH
, NULL AS ORIG_SYS_REF
, TO_DATE (NULL) AS MODEL_LAST_UPDATE_DATE
, TO_NUMBER (NULL) AS MODEL_LAST_UPDATED_BY
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.DATA_VALUE AS DETAILED_OBJECT_TYPE
, CZTEXTPROPERTIES.DATA_TYPE AS PROPERTY_DATA_TYPE
, CZTEXTPROPERTIES.DEF_VALUE AS PROPERTY_DEF_VALUE
, CZTEXTPROPERTIES.DEF_NUM_VALUE AS PROPERTY_DEF_NUM_VALUE
, CZTEXTS.TEXT_STR AS PROPERTY_DEF_LOCAL_TEXT
, NULL AS LOCK_STATUS
, TO_DATE (NULL) AS CHECKOUT_TIME
, NULL AS REF_PART_NBR
, NULL AS EFFECTIVE_FROM
, NULL AS EFFECTIVE_UNTIL
, NULL AS CONFIG_ENGINE_TYPE
FROM CZ_RP_ENTRIES CZRPENTRIESEO
, (SELECT 'PRP' AS PROJECT_TYPE
, INNERTEXTPRP.PROPERTY_ID
, INNERTEXTPRP.DATA_TYPE
, INNERTEXTPRP.DEF_VALUE
, INNERTEXTPRP.DELETED_FLAG
, INNERTEXTPRP.LAST_UPDATED_BY
, INNERTEXTPRP.CHECKOUT_USER
, INNERTEXTPRP.LAST_UPDATE_DATE
, INNERTEXTPRP.DEF_NUM_VALUE
FROM CZ_PROPERTIES INNERTEXTPRP
WHERE INNERTEXTPRP.DELETED_FLAG = '0'
AND INNERTEXTPRP.DATA_TYPE = 8) CZTEXTPROPERTIES
, (SELECT TRANSTEXTS.INTL_TEXT_ID
, TRANSTEXTS.TEXT_STR
FROM CZ_LOCALIZED_TEXTS_VL TRANSTEXTS
WHERE TRANSTEXTS.DELETED_FLAG = '0') CZTEXTS
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZRPENTRIESEO.DELETED_FLAG = '0'
AND CZRPENTRIESEO.OBJECT_TYPE = CZTEXTPROPERTIES.PROJECT_TYPE
AND CZRPENTRIESEO.OBJECT_ID = CZTEXTPROPERTIES.PROPERTY_ID
AND CZTEXTS.INTL_TEXT_ID = CZTEXTPROPERTIES.DEF_NUM_VALUE
AND CZRPENTRIESEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE
AND ( CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1' )
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0 UNION ALL SELECT CZRPENTRIESEO.OBJECT_TYPE
, CZRPENTRIESEO.OBJECT_ID
, CZRPENTRIESEO.ENCLOSING_FOLDER
, CZRPENTRIESEO.NAME
, CZRPENTRIESEO.DESCRIPTION
, CZRPENTRIESEO.NOTES
, CZRPENTRIESEO.DELETED_FLAG
, CZRPENTRIESEO.CREATED_BY
, CZRPENTRIESEO.CREATION_DATE
, CZRPENTRIESEO.LAST_UPDATED_BY
, CZRPENTRIESEO.LAST_UPDATE_DATE
, CZRPENTRIESEO.SEEDED_FLAG
, 'T' AS HAS_ENTITY_PRIV
, DECODE (CZTEMPLATES.CHECKOUT_USER
, NULL
, '0'
, FND_GLOBAL.USER_NAME
, '1'
, '2' ) AS USER_LOCK_STATUS
, 'T' AS IS_MODEL_EDITABLE
, CZTEMPLATES.CHECKOUT_USER
, NULL AS PRODUCT_KEY
, TO_NUMBER (NULL) AS ORGANIZATION_ID
, TO_NUMBER (NULL) AS INVENTORY_ITEM_ID
, NULL AS MODEL_TYPE
, CZ_DEVELOPER_UTILS_PVT.GET_REPOSITORY_PATH (OBJECT_ID
, OBJECT_TYPE ) AS PATH
, NULL AS ORIG_SYS_REF
, TO_DATE (NULL) AS MODEL_LAST_UPDATE_DATE
, TO_NUMBER (NULL) AS MODEL_LAST_UPDATED_BY
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.DATA_VALUE AS DETAILED_OBJECT_TYPE
, TO_NUMBER (NULL) AS PROPERTY_DATA_TYPE
, NULL AS PROPERTY_DEF_VALUE
, TO_NUMBER (NULL) AS PROPERTY_DEF_NUM_VALUE
, NULL AS PROPERTY_DEF_LOCAL_TEXT
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CZ_YES_NO_TYPE'
AND LOOKUP_CODE = DECODE (CZTEMPLATES.CHECKOUT_USER
, NULL
, 'N'
, 'Y' )) AS LOCK_STATUS
, CZTEMPLATES.CHECKOUT_TIME
, NULL AS REF_PART_NBR
, NULL AS EFFECTIVE_FROM
, NULL AS EFFECTIVE_UNTIL
, NULL AS CONFIG_ENGINE_TYPE
FROM CZ_RP_ENTRIES CZRPENTRIESEO
, (SELECT 'UCT' AS TEMPLATE_TYPE
, INNERUIT.TEMPLATE_ID
, INNERUIT.UI_DEF_ID
, INNERUIT.CHECKOUT_USER
, INNERUIT.CHECKOUT_TIME
FROM CZ_UI_TEMPLATES INNERUIT
WHERE INNERUIT.DELETED_FLAG = '0') CZTEMPLATES
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZRPENTRIESEO.DELETED_FLAG = '0'
AND CZRPENTRIESEO.OBJECT_TYPE = CZTEMPLATES.TEMPLATE_TYPE
AND CZRPENTRIESEO.OBJECT_ID = CZTEMPLATES.TEMPLATE_ID
AND CZTEMPLATES.UI_DEF_ID = 0
AND CZRPENTRIESEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE
AND ( CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.SEEDED_FLAG = '1' )
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0

Columns