FND Design Data [Home] [Help]

View: CZ_MODEL_REFERENCES_PICKER_V

Product: CZ - Configurator
Description:
Implementation/DBA Data: ViewAPPS.CZ_MODEL_REFERENCES_PICKER_V
View Text

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

Columns

Name
OBJECT_ID
OBJECT_TYPE
ENCLOSING_FOLDER
NAME
DELETED_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
SEEDED_FLAG
CHECKOUT_USER
PRODUCT_KEY
ORGANIZATION_ID
INVENTORY_ITEM_ID
MODEL_TYPE
PATH
ORIG_SYS_REF
DESC_TEXT
ALT_TEXT
OBJECT_TYPE_DESC
IMAGE_FILE
FULL_IMAGE_PATH
CONFIG_ENGINE_TYPE