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

TABLE: MSC.MSC_BOM_TEMP

Object Details
Object Name: MSC_BOM_TEMP
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_BOM_TEMP
Subobject Name:
Status: VALID


This temporary table stores information on the bill of materials during ATP processing


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

MSC.MSC_BOM_TEMP does not reference any database object

MSC.MSC_BOM_TEMP is referenced by following:

SchemaMSC
ViewMSC_BOM_TEMP#