VIEW: APPS.CZ_MODEL_APPLICABILITIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'