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

VIEW: MSC.MSC_BOM_COMPONENTS#

Object Details
Object Name: MSC_BOM_COMPONENTS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
COMPONENT_SEQUENCE_ID NUMBER
Yes
BILL_SEQUENCE_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
USING_ASSEMBLY_ID NUMBER

COMPONENT_TYPE NUMBER

SCALING_TYPE NUMBER

CHANGE_NOTICE VARCHAR2 (10)
REVISION VARCHAR2 (3)
UOM_CODE VARCHAR2 (3)
USAGE_QUANTITY NUMBER

EFFECTIVITY_DATE DATE

DISABLE_DATE DATE

FROM_UNIT_NUMBER VARCHAR2 (30)
TO_UNIT_NUMBER VARCHAR2 (30)
USE_UP_CODE NUMBER

SUGGESTED_EFFECTIVITY_DATE DATE

DRIVING_ITEM_ID NUMBER

OPERATION_OFFSET_PERCENT NUMBER

OPTIONAL_COMPONENT NUMBER

OLD_EFFECTIVITY_DATE DATE

WIP_SUPPLY_TYPE NUMBER

PLANNING_FACTOR NUMBER

ATP_FLAG NUMBER

COMPONENT_YIELD_FACTOR NUMBER
Yes
REFRESH_NUMBER NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SCALE_MULTIPLE NUMBER

SCALE_ROUNDING_VARIANCE NUMBER

ROUNDING_DIRECTION NUMBER

PRIMARY_FLAG NUMBER

CONTRIBUTE_TO_STEP_QTY NUMBER

OLD_COMPONENT_SEQUENCE_ID NUMBER

OPERATION_SEQ_NUM NUMBER

NEW_PLAN_ID NUMBER

NEW_PLAN_LIST VARCHAR2 (256)
APPLIED NUMBER

SIMULATION_SET_ID NUMBER

BASE_MODEL_ITEM_ID NUMBER

Query Text

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


SELECT PLAN_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      USING_ASSEMBLY_ID
,      COMPONENT_TYPE
,      SCALING_TYPE
,      CHANGE_NOTICE
,      REVISION
,      UOM_CODE
,      USAGE_QUANTITY
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      FROM_UNIT_NUMBER
,      TO_UNIT_NUMBER
,      USE_UP_CODE
,      SUGGESTED_EFFECTIVITY_DATE
,      DRIVING_ITEM_ID
,      OPERATION_OFFSET_PERCENT
,      OPTIONAL_COMPONENT
,      OLD_EFFECTIVITY_DATE
,      WIP_SUPPLY_TYPE
,      PLANNING_FACTOR
,      ATP_FLAG
,      COMPONENT_YIELD_FACTOR
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SCALE_MULTIPLE
,      SCALE_ROUNDING_VARIANCE
,      ROUNDING_DIRECTION
,      PRIMARY_FLAG
,      CONTRIBUTE_TO_STEP_QTY
,      OLD_COMPONENT_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      NEW_PLAN_ID
,      NEW_PLAN_LIST
,      APPLIED
,      SIMULATION_SET_ID
,      BASE_MODEL_ITEM_ID
FROM MSC.MSC_BOM_COMPONENTS#;

Dependencies

[top of page]

MSC.MSC_BOM_COMPONENTS# references the following:

SchemaMSC
TableMSC_BOM_COMPONENTS
MSC.MSC_BOM_COMPONENTS# is referenced by following:

SchemaAPPS
SynonymMSC_BOM_COMPONENTS