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

TABLE: MSD.MSD_SOP_COLLAPSED_BOM_COMP

Object Details
Object Name: MSD_SOP_COLLAPSED_BOM_COMP
Object Type: TABLE
Owner: MSD
Subobject Name:
Status: VALID


This table contains Capacity Usage Ratio by Sales and Operations plan. It contains flat bom structure.
This was used for Sales and Operations Planning. This table is no longer in use.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID VARCHAR2 (30)
The source instance ID.
DEMAND_PLAN_ID NUMBER

SOP Plan unique ID.
SR_ASSEMBLY_PK VARCHAR2 (240)
Source primary key for the assembly.
SR_COMPONENT_PK VARCHAR2 (240)
Source primary key for the component.
EFFECTIVITY_DATE DATE

Effective date for collapse bom structure.
DISABLE_DATE DATE

Disable date for Collapse bom structure.
RES_COMP VARCHAR2 (240)
Flag to denote whether is is resource or component I- Item , R- Resource , L-Flow Resource.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
PLAN_TYPE VARCHAR2 (15)
Type of plan - SOP or EOL
BOM_TYPE VARCHAR2 (15)
Type of BOM
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SR_INSTANCE_ID
,      DEMAND_PLAN_ID
,      SR_ASSEMBLY_PK
,      SR_COMPONENT_PK
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      RES_COMP
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PLAN_TYPE
,      BOM_TYPE
FROM MSD.MSD_SOP_COLLAPSED_BOM_COMP;

Dependencies

[top of page]

MSD.MSD_SOP_COLLAPSED_BOM_COMP does not reference any database object

MSD.MSD_SOP_COLLAPSED_BOM_COMP is referenced by following:

SchemaAPPS
SynonymMSD_SOP_COLLAPSED_BOM_COMP