[Home] [Help] [Dependency Information]
Object Name: | CZ_MODEL_APPLICABILITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_MODEL_APPLICABILITIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
CZ_MODEL_APPLICABILITIES_V is used to associate published models with all their applicable Usages and client Applications. It is used during runtime resolution of a configurator Initialize request.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | (9) | Inventory_item_id of the item that is the model root | |
BOM_EXPLOSION_ORG_ID | NUMBER | (9) | Organization identifier of the organization that the item is found in | |
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 | |
MODEL_ID | NUMBER | Yes | ||
PUBLICATION_ID | NUMBER | (9) | Yes | |
START_DATE | DATE | Yes | Identifies a publication for this record | |
DISABLE_DATE | DATE | Yes | Standard start date for applicability | |
PUBLICATION_MODE | VARCHAR2 | (1) | Yes | Flag indicating the mode of publication. DEFAULT'T' indicates "Testing"; 'P' indicates "Production" |
FND_APPLICATION_ID | NUMBER | (9) | Yes | Numeric identity of the client application from the FND application list |
USAGE_ID | NUMBER | (9) | Yes | Specifies a usage for which this model publication is applicable |
SERVER_ID | NUMBER | (9) | Yes | Associates this record with a database-server instance |
USER_ID | NUMBER | UNUSED | ||
RESPONSIBILITY_ID | NUMBER | Associates this model with an Apps responsibility. Foreign key reference to fnd_responsibility.responsibility_id. | ||
UI_DEF_ID | NUMBER | (9) | Identifies a User Interface for this record | |
UI_STYLE | VARCHAR2 | (3) | Yes | Contains the UI Style of the published UI (denormalization from CZ_UI_DEFS) |
PS_NODE_ID | NUMBER | (15) | Associates this record with a Model structure node ('psnode') | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
CREATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that created this record |
LAST_UPDATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that last updated this record |
USER_NUM01 | NUMBER | (9) | Standard extension field (numeric) | |
USER_NUM02 | NUMBER | (9) | Standard extension field (numeric) | |
USER_NUM03 | NUMBER | (9) | Standard extension field (numeric) | |
USER_NUM04 | NUMBER | (9) | Standard extension field (numeric) | |
USER_STR01 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR02 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR03 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR04 | VARCHAR2 | (255) | Standard extension field (string) | |
SOURCE_TARGET_FLAG | VARCHAR2 | (1) | Yes | S - indicates this is a 'source' publication 'owned' by Developer; T - indicates this is a 'target' publication created by procsand used by Runtime |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
LANGUAGE | VARCHAR2 | (4) | Yes | Identifies a language for which this model publication is applicable |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, BOM_EXPLOSION_ORG_ID
, PRODUCT_KEY
, MODEL_ID
, PUBLICATION_ID
, START_DATE
, DISABLE_DATE
, PUBLICATION_MODE
, FND_APPLICATION_ID
, USAGE_ID
, SERVER_ID
, USER_ID
, RESPONSIBILITY_ID
, UI_DEF_ID
, UI_STYLE
, PS_NODE_ID
, DELETED_FLAG
, CREATED_BY
, LAST_UPDATED_BY
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, SOURCE_TARGET_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, LANGUAGE
FROM APPS.CZ_MODEL_APPLICABILITIES_V;
|
|
|