Product: | CZ - Configurator |
---|---|
Description: | Enumerates applicabilities of a published model |
Implementation/DBA Data: | APPS.CZ_MODEL_APPLICABILITIES_V |
SELECT CZ_MODEL_PUBLICATIONS.TOP_ITEM_ID AS INVENTORY_ITEM_ID
, CZ_MODEL_PUBLICATIONS.ORGANIZATION_ID AS BOM_EXPLOSION_ORG_ID
, CZ_MODEL_PUBLICATIONS.PRODUCT_KEY
, CZ_MODEL_PUBLICATIONS.OBJECT_ID AS MODEL_ID
, CZ_MODEL_PUBLICATIONS.PUBLICATION_ID
, CZ_MODEL_PUBLICATIONS.APPLICABLE_FROM AS START_DATE
, CZ_MODEL_PUBLICATIONS.APPLICABLE_UNTIL AS DISABLE_DATE
, CZ_MODEL_PUBLICATIONS.PUBLICATION_MODE
, CZ_PB_CLIENT_APPS.FND_APPLICATION_ID
, CZ_PUBLICATION_USAGES.USAGE_ID
, CZ_MODEL_PUBLICATIONS.SERVER_ID
, TO_NUMBER(NULL) AS USER_ID
, TO_NUMBER(NULL) AS RESPONSIBILITY_ID
, CZ_MODEL_PUBLICATIONS.UI_DEF_ID
, CZ_MODEL_PUBLICATIONS.UI_STYLE
, CZ_MODEL_PUBLICATIONS.MODEL_ID AS PS_NODE_ID
, CZ_MODEL_PUBLICATIONS.DELETED_FLAG
, CZ_MODEL_PUBLICATIONS.CREATED_BY
, CZ_MODEL_PUBLICATIONS.LAST_UPDATED_BY
, CZ_MODEL_PUBLICATIONS.USER_NUM01
, CZ_MODEL_PUBLICATIONS.USER_NUM02
, CZ_MODEL_PUBLICATIONS.USER_NUM03
, CZ_MODEL_PUBLICATIONS.USER_NUM04
, CZ_MODEL_PUBLICATIONS.USER_STR01
, CZ_MODEL_PUBLICATIONS.USER_STR02
, CZ_MODEL_PUBLICATIONS.USER_STR03
, CZ_MODEL_PUBLICATIONS.USER_STR04
, CZ_MODEL_PUBLICATIONS.SOURCE_TARGET_FLAG
, CZ_MODEL_PUBLICATIONS.CREATION_DATE
, CZ_MODEL_PUBLICATIONS.LAST_UPDATE_DATE
, CZ_PB_LANGUAGES.LANGUAGE
FROM CZ_MODEL_PUBLICATIONS
, CZ_PB_CLIENT_APPS
, CZ_PUBLICATION_USAGES
, CZ_PB_LANGUAGES
WHERE CZ_MODEL_PUBLICATIONS.EXPORT_STATUS <> 'ERR'
AND CZ_MODEL_PUBLICATIONS.PUBLICATION_ID = CZ_PB_CLIENT_APPS.PUBLICATION_ID
AND CZ_MODEL_PUBLICATIONS.PUBLICATION_ID = CZ_PUBLICATION_USAGES.PUBLICATION_ID
AND CZ_MODEL_PUBLICATIONS.PUBLICATION_ID = CZ_PB_LANGUAGES.PUBLICATION_ID
AND CZ_MODEL_PUBLICATIONS.OBJECT_TYPE = 'PRJ'
AND CZ_MODEL_PUBLICATIONS.DISABLED_FLAG='0'