[Home] [Help]
[Dependency Information]
| Object Name: | CST_WIP_ENTITY_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BOM.CST_WIP_ENTITY_VIEW
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WIP_ENTITY_ID | NUMBER | WIP job or repetitive assembly identifier | ||
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| WIP_ENTITY_NAME | VARCHAR2 | (240) | WIP job or repetitive assembly name | |
| ENTITY_DESCRIPTION | VARCHAR2 | (240) | Description of the discrete job or repetitive assembly | |
| ENTITY_TYPE | NUMBER | WIP entity type code | ||
| LINE_ID | NUMBER | WIP repetitive line identifier | ||
| LINE_CODE | VARCHAR2 | (10) | WIP repetitive line name | |
| PRIMARY_ITEM_ID | NUMBER | Inventory item identifier of assembly the job or schedule creates | ||
| CLASS_CODE | VARCHAR2 | (10) | Accounting class associated with job or repetitive assembly |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, ORGANIZATION_ID
, WIP_ENTITY_NAME
, ENTITY_DESCRIPTION
, ENTITY_TYPE
, LINE_ID
, LINE_CODE
, PRIMARY_ITEM_ID
, CLASS_CODE
FROM APPS.CST_WIP_ENTITY_VIEW;
APPS
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_LINES
WIP_REPETITIVE_ITEMS
APPS.CST_WIP_ENTITY_VIEW is not referenced by any database object
|
|
|
|