[Home] [Help] [Dependency Information]
Object Name: | CZ_SRC_MODEL_PUBLICATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_SRC_MODEL_PUBLICATIONS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PUBLICATION_ID | NUMBER | (9) | Yes | Identifies a publication for this record |
OBJECT_ID | NUMBER | (15) | Associates this record with a configurator Model/Project | |
SERVER_ID | NUMBER | (9) | Yes | Associates this record with a database-server instance |
ORGANIZATION_ID | NUMBER | (9) | Organization ID for this published model if imported from BOM | |
TOP_ITEM_ID | NUMBER | (9) | Bill top item identifier for this model if applicable | |
PRODUCT_KEY | VARCHAR2 | (255) | String value used as an identifier for the published model/project. Generally not used for imported models, which are referenced through organization ID and inventory item ID | |
PUBLICATION_MODE | VARCHAR2 | (1) | Yes | Flag indicating the mode of publication. DEFAULT'T' indicates "Testing"; 'P' indicates "Production" |
UI_DEF_ID | NUMBER | (9) | Identifies a User Interface for this record | |
UI_STYLE | VARCHAR2 | (3) | Yes | Specifies the style of the published user interface (DENORMALIZATION): 0 - Components Tree (default); 1 - Navigation Tree; 2 - Wizard; 3 - Model Tree |
APPLICABLE_FROM | DATE | Yes | Indicates the configuration date beginning on which this publication becomes applicable. | |
APPLICABLE_UNTIL | DATE | Yes | Indicates the date at which this publication is no longer applicable (EXCLUSIVE). | |
EXPORT_STATUS | VARCHAR2 | (3) | Export status as from the CZ_XFR_MODEL_EXPORTS table for this model (dependent on child models' export status). 'PEN' - export is pending; 'PRC' - export is being processed; 'OK' - export has completed; 'PUP' - update is pending; 'ERR' - export has failed | |
CREATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that created this record |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that last updated this record |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
PAGE_LAYOUT | VARCHAR2 | (2000) | ||
CONTAINER | VARCHAR2 | (2000) | ||
DISABLED_FLAG | VARCHAR2 | (1) | Yes | Date on which the publication (export) process finished. |
Cut, paste (and edit) the following text to query this object:
SELECT PUBLICATION_ID
, OBJECT_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 APPS.CZ_SRC_MODEL_PUBLICATIONS_V;
APPS.CZ_SRC_MODEL_PUBLICATIONS_V is not referenced by any database object
|
|
|