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

TABLE: BOM.BOM_MIXED_MODEL_MAP_RES

Object Details
Object Name: BOM_MIXED_MODEL_MAP_RES
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_MIXED_MODEL_MAP_RES
Subobject Name:
Status: VALID


BOM_MIXED_MODEL_MAP_RES contains information of resources
for mixed model maps.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_MIXED_MODEL_MAP_RES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMIXED_MODEL_MAP_ID
Columns
Name Datatype Length Mandatory Comments
MIXED_MODEL_MAP_ID NUMBER
Yes Mixed model map internal identifier
RESOURCE_ID NUMBER
Yes Resource unique identifier
RESOURCE_CODE VARCHAR2 (10)
Resouce code
ACTIVITY_ID NUMBER

Activity identifier
ACTIVITY VARCHAR2 (10)
Activity name
STANDARD_OPERATION_ID NUMBER

Standard operation unique identifier
OPERATION_CODE VARCHAR2 (4)
Operation code
ORGANIZATION_ID NUMBER

Organization identifier
RESOURCE_TYPE NUMBER

Resource type
RESOURCE_NEEDED NUMBER

Resource needed for the operation
Query Text

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_NEEDED
FROM BOM.BOM_MIXED_MODEL_MAP_RES;

Dependencies

[top of page]

BOM.BOM_MIXED_MODEL_MAP_RES does not reference any database object

BOM.BOM_MIXED_MODEL_MAP_RES is referenced by following:

SchemaAPPS
SynonymBOM_MIXED_MODEL_MAP_RES