VIEW: APPS.CZ_REPOSITORY_MAIN_HGRID_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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