VIEW: APPS.CZ_MODEL_REFERENCES_PICKER_V

Source

View Text - Preformatted

SELECT CZRpEntriesEO.OBJECT_ID, CZRpEntriesEO.OBJECT_TYPE, CZRpEntriesEO.ENCLOSING_FOLDER, CZRpEntriesEO.NAME, CZRpEntriesEO.DELETED_FLAG, CZRpEntriesEO.CREATED_BY, CZRpEntriesEO.CREATION_DATE, CZRpEntriesEO.LAST_UPDATED_BY, CZRpEntriesEO.LAST_UPDATE_DATE, CZRpEntriesEO.SEEDED_FLAG, 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, CZRpEntriesEO.DESCRIPTION as DESC_TEXT, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION as ALT_TEXT, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION as object_type_desc, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH, CZDevlProjects.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, INNERPRJ.LAST_UPDATED_BY, NVL(INNERPRJ.CONFIG_ENGINE_TYPE,'L') as CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS INNERPRJ ) CZDevlProjects,CZ_UI_PATHED_IMAGES_V, CZ_RPOBJECTTYPES_LKV WHERE CzRpEntriesEO.OBJECT_ID = CzDevlProjects.DEVL_PROJECT_ID AND CzRpEntriesEO.OBJECT_TYPE = 'PRJ' AND CzRpEntriesEO.deleted_flag = '0' AND ( CZRpEntriesEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE IS NOT NULL) 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.UI_DEF_ID = 0) AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30 UNION ALL SELECT CZRpEntriesEO.OBJECT_ID, CZRpEntriesEO.OBJECT_TYPE, CZRpEntriesEO.ENCLOSING_FOLDER, CZRpEntriesEO.NAME, CZRpEntriesEO.DELETED_FLAG, CZRpEntriesEO.CREATED_BY, CZRpEntriesEO.CREATION_DATE, CZRpEntriesEO.LAST_UPDATED_BY, CZRpEntriesEO.LAST_UPDATE_DATE, CZRpEntriesEO.SEEDED_FLAG, NULL as 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, CZRpEntriesEO.DESCRIPTION as DESC_TEXT, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION as ALT_TEXT, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION as object_type_desc, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH, NULL as CONFIG_ENGINE_TYPE FROM CZ_RP_ENTRIES CZRpEntriesEO,CZ_UI_PATHED_IMAGES_V,CZ_RPOBJECTTYPES_LKV WHERE CzRpEntriesEO.OBJECT_TYPE = 'FLD' AND CzRpEntriesEO.deleted_flag = '0' AND ( CZRpEntriesEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE IS NOT NULL) 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.UI_DEF_ID = 0) AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30

View Text - HTML Formatted

SELECT CZRPENTRIESEO.OBJECT_ID
, CZRPENTRIESEO.OBJECT_TYPE
, CZRPENTRIESEO.ENCLOSING_FOLDER
, CZRPENTRIESEO.NAME
, CZRPENTRIESEO.DELETED_FLAG
, CZRPENTRIESEO.CREATED_BY
, CZRPENTRIESEO.CREATION_DATE
, CZRPENTRIESEO.LAST_UPDATED_BY
, CZRPENTRIESEO.LAST_UPDATE_DATE
, CZRPENTRIESEO.SEEDED_FLAG
, 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
, CZRPENTRIESEO.DESCRIPTION AS DESC_TEXT
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZDEVLPROJECTS.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
, INNERPRJ.LAST_UPDATED_BY
, NVL(INNERPRJ.CONFIG_ENGINE_TYPE
, 'L') AS CONFIG_ENGINE_TYPE
FROM CZ_DEVL_PROJECTS INNERPRJ ) CZDEVLPROJECTS
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZRPENTRIESEO.OBJECT_ID = CZDEVLPROJECTS.DEVL_PROJECT_ID
AND CZRPENTRIESEO.OBJECT_TYPE = 'PRJ'
AND CZRPENTRIESEO.DELETED_FLAG = '0'
AND ( CZRPENTRIESEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE
AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE IS NOT NULL)
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.UI_DEF_ID = 0)
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30 UNION ALL SELECT CZRPENTRIESEO.OBJECT_ID
, CZRPENTRIESEO.OBJECT_TYPE
, CZRPENTRIESEO.ENCLOSING_FOLDER
, CZRPENTRIESEO.NAME
, CZRPENTRIESEO.DELETED_FLAG
, CZRPENTRIESEO.CREATED_BY
, CZRPENTRIESEO.CREATION_DATE
, CZRPENTRIESEO.LAST_UPDATED_BY
, CZRPENTRIESEO.LAST_UPDATE_DATE
, CZRPENTRIESEO.SEEDED_FLAG
, NULL AS 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
, CZRPENTRIESEO.DESCRIPTION AS DESC_TEXT
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, NULL AS CONFIG_ENGINE_TYPE
FROM CZ_RP_ENTRIES CZRPENTRIESEO
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZRPENTRIESEO.OBJECT_TYPE = 'FLD'
AND CZRPENTRIESEO.DELETED_FLAG = '0'
AND ( CZRPENTRIESEO.OBJECT_TYPE = CZ_RPOBJECTTYPES_LKV.DATA_VALUE
AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE IS NOT NULL)
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.UI_DEF_ID = 0)
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30