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

TABLE: MSD.MSD_ASCP_BOM_COMP

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


This table contains Capacity Usage Ratio by ASCP 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)
Source Instance Identifier
CAP_USG_RATIO_OBJ VARCHAR2 (240)
Capacity Usage Ratio Object Name
SR_ASSEMBLY_PK VARCHAR2 (240)
Assembly Identifier in source
SR_COMPONENT_PK VARCHAR2 (240)
Component Idetifier in source
EFFECTIVITY_DATE DATE

Effective Date
DISABLE_DATE DATE

Disable Date
RES_COMP VARCHAR2 (240)
Resource Component
CAPACITY_USAGE_RATIO NUMBER

Capacity Usage Ratio
LEAD_TIME NUMBER

Lead Time
LAST_COLLECTED_DATE DATE

Last Collected Date
LAST_UPDATE_DATE DATE

Last Update date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

creation Date
CREATED_BY NUMBER

Created by
PLAN_TYPE VARCHAR2 (15)
Plan Type. Possible Values - SOP, 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
,      CAP_USG_RATIO_OBJ
,      SR_ASSEMBLY_PK
,      SR_COMPONENT_PK
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      RES_COMP
,      CAPACITY_USAGE_RATIO
,      LEAD_TIME
,      LAST_COLLECTED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PLAN_TYPE
,      BOM_TYPE
FROM MSD.MSD_ASCP_BOM_COMP;

Dependencies

[top of page]

MSD.MSD_ASCP_BOM_COMP does not reference any database object

MSD.MSD_ASCP_BOM_COMP is referenced by following:

SchemaMSD
ViewMSD_ASCP_BOM_COMP#