[Home] [Help]
[Dependency Information]
| Object Name: | BOM_MIXED_MODEL_MAP_RES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BOM.BOM_MIXED_MODEL_MAP_RES_V
|
| 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 |
|---|---|---|---|---|
| MIXED_MODEL_MAP_ID | NUMBER | Yes | Mixed model map unique identifier | |
| RESOURCE_ID | NUMBER | Yes | Resouce identifier | |
| RESOURCE_CODE | VARCHAR2 | (10) | Resource code | |
| ACTIVITY_ID | NUMBER | Activity identifier | ||
| ACTIVITY | VARCHAR2 | (10) | Activity name | |
| STANDARD_OPERATION_ID | NUMBER | Standard operation identifier | ||
| OPERATION_CODE | VARCHAR2 | (4) | Operation code | |
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| RESOURCE_TYPE | NUMBER | Rsource type | ||
| RESOURCE_TYPE_DISP | VARCHAR2 | (80) | Lookup meaning | |
| RESOURCE_NEEDED | NUMBER | Resource needed for the operation |
Cut, paste (and edit) the following text to query this object:
SELECT MIXED_MODEL_MAP_ID
, RESOURCE_ID
, RESOURCE_CODE
, ACTIVITY_ID
, ACTIVITY
, STANDARD_OPERATION_ID
, OPERATION_CODE
, ORGANIZATION_ID
, RESOURCE_TYPE
, RESOURCE_TYPE_DISP
, RESOURCE_NEEDED
FROM APPS.BOM_MIXED_MODEL_MAP_RES_V;
APPS
BOM_MIXED_MODEL_MAP_RES
MFG_LOOKUPS
APPS.BOM_MIXED_MODEL_MAP_RES_V is not referenced by any database object
|
|
|
|