[Home] [Help] [Dependency Information]
Object Name: | CZ_MODELS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_MODELS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
CZ_MODELS_V provides the mapping from an item_id to a configuration model.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory_item_id of the item that is the model root | |
BOM_EXPLOSION_ORG_ID | NUMBER | Yes | Organization identifier of the organization that the item is found in | |
START_DATE | DATE | Standard start date for effectivity | ||
DISABLE_DATE | DATE | Standard end date for effectivity | ||
USER_ID | NUMBER | Foreign key reference to fnd_user.user_id. Will be null in the 11i release | ||
RESPONSIBILITY_ID | NUMBER | Foreign key reference to fnd_responsibility.responsibility_id. Will be null in the 11i release | ||
UI_DEF_ID | NUMBER | Identifier for the configuration UI to be used | ||
PS_NODE_ID | NUMBER | (15) | Yes | Root of the configuration model. Will be used to validate in batch mode, but will not be used when running the UI |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, BOM_EXPLOSION_ORG_ID
, START_DATE
, DISABLE_DATE
, USER_ID
, RESPONSIBILITY_ID
, UI_DEF_ID
, PS_NODE_ID
FROM APPS.CZ_MODELS_V;
APPS.CZ_MODELS_V is not referenced by any database object
|
|
|