[Home] [Help] [Dependency Information]
Object Name: | MSC_BOM_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_BOM_TEMP |
Subobject Name: | |
Status: | VALID |
This temporary table stores information on the bill of materials during ATP processing
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | Session Id | |
ASSEMBLY_IDENTIFIER | NUMBER | Yes | Assembly Identifier | |
ASSEMBLY_ITEM_ID | NUMBER | Yes | Assembly Item Id | |
COMPONENT_IDENTIFIER | NUMBER | Component Identifier | ||
COMPONENT_ITEM_ID | NUMBER | Yes | Component Item Id | |
QUANTITY | NUMBER | Yes | Quantity of component needed per item | |
FIXED_LT | NUMBER | Fixed Lead Time | ||
VARIABLE_LT | NUMBER | Variable Lead Time | ||
EFFECTIVE_DATE | DATE | Effective Date | ||
DISABLE_DATE | DATE | Disable Date | ||
ATP_CHECK | NUMBER | Atp Check | ||
WIP_SUPPLY_TYPE | NUMBER | Wip Supply Type | ||
SMC_FLAG | VARCHAR2 | (1) | Standard mandatory component flag | |
PRE_PROCESS_LT | NUMBER | Preprocessing Lead Time | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source Organization ID to fix Sourcing mismatch for Multi-Org ATO Models | ||
ATP_FLAG | VARCHAR2 | (1) | ATP flag value for a given item on source |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, ASSEMBLY_IDENTIFIER
, ASSEMBLY_ITEM_ID
, COMPONENT_IDENTIFIER
, COMPONENT_ITEM_ID
, QUANTITY
, FIXED_LT
, VARIABLE_LT
, EFFECTIVE_DATE
, DISABLE_DATE
, ATP_CHECK
, WIP_SUPPLY_TYPE
, SMC_FLAG
, PRE_PROCESS_LT
, SOURCE_ORGANIZATION_ID
, ATP_FLAG
FROM MSC.MSC_BOM_TEMP;
MSC.MSC_BOM_TEMP does not reference any database object
MSC.MSC_BOM_TEMP is referenced by following:
|
|
|