DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CZ_MODELS_V

Object Details
Object Name: CZ_MODELS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_MODELS_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.CZ_MODELS_V references the following:

SchemaAPPS
SynonymCZ_XFR_PROJECT_BILLS

APPS.CZ_MODELS_V is not referenced by any database object