VIEW: APPS.CZ_TGT_MODEL_PUBLICATIONS_V

Source

View Text - Preformatted

SELECT PUBLICATION_ID, MODEL_ID, SERVER_ID, ORGANIZATION_ID, TOP_ITEM_ID, PRODUCT_KEY, PUBLICATION_MODE, UI_DEF_ID, UI_STYLE, APPLICABLE_FROM, APPLICABLE_UNTIL, EXPORT_STATUS, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, PAGE_LAYOUT, CONTAINER, DISABLED_FLAG from cz_model_publications WHERE deleted_flag = '0' and object_type = 'PRJ' and source_target_flag = 'T'

View Text - HTML Formatted

SELECT PUBLICATION_ID
, MODEL_ID
, SERVER_ID
, ORGANIZATION_ID
, TOP_ITEM_ID
, PRODUCT_KEY
, PUBLICATION_MODE
, UI_DEF_ID
, UI_STYLE
, APPLICABLE_FROM
, APPLICABLE_UNTIL
, EXPORT_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PAGE_LAYOUT
, CONTAINER
, DISABLED_FLAG
FROM CZ_MODEL_PUBLICATIONS
WHERE DELETED_FLAG = '0'
AND OBJECT_TYPE = 'PRJ'
AND SOURCE_TARGET_FLAG = 'T'