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

VIEW: MSC.MSC_ST_BOM_COMPONENTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER

ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

USING_ASSEMBLY_ID NUMBER

BILL_SEQUENCE_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

REVISED_ITEM_SEQUENCE_ID NUMBER

STATUS_TYPE NUMBER

DELETED_FLAG NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_INSTANCE_ID NUMBER

REFRESH_ID NUMBER

COMPANY_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
BOM_NAME VARCHAR2 (250)
ORGANIZATION_CODE VARCHAR2 (7)
ASSEMBLY_NAME VARCHAR2 (250)
SR_INSTANCE_CODE VARCHAR2 (3)
COMPONENT_NAME VARCHAR2 (250)
OPERATION_SEQ_CODE VARCHAR2 (10)
DRIVING_ITEM_NAME VARCHAR2 (250)
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (40)
ERROR_TEXT VARCHAR2 (2000)
MESSAGE_ID NUMBER

PROCESS_FLAG NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ST_TRANSACTION_ID NUMBER

BATCH_ID NUMBER

SCALE_MULTIPLE NUMBER

SCALE_ROUNDING_VARIANCE NUMBER

ROUNDING_DIRECTION NUMBER

PRIMARY_FLAG NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_BILL_SEQUENCE_ID NUMBER

SOURCE_COMPONENT_SEQUENCE_ID NUMBER

SOURCE_USING_ASSEMBLY_ID NUMBER

SOURCE_INVENTORY_ITEM_ID NUMBER

SOURCE_DRIVING_ITEM_ID NUMBER

CONTRIBUTE_TO_STEP_QTY NUMBER

OLD_COMPONENT_SEQUENCE_ID NUMBER

OPERATION_SEQ_NUM NUMBER

Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      USING_ASSEMBLY_ID
,      BILL_SEQUENCE_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
,      REVISED_ITEM_SEQUENCE_ID
,      STATUS_TYPE
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      COMPANY_ID
,      COMPANY_NAME
,      BOM_NAME
,      ORGANIZATION_CODE
,      ASSEMBLY_NAME
,      SR_INSTANCE_CODE
,      COMPONENT_NAME
,      OPERATION_SEQ_CODE
,      DRIVING_ITEM_NAME
,      ALTERNATE_BOM_DESIGNATOR
,      ERROR_TEXT
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      SCALE_MULTIPLE
,      SCALE_ROUNDING_VARIANCE
,      ROUNDING_DIRECTION
,      PRIMARY_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_COMPONENT_SEQUENCE_ID
,      SOURCE_USING_ASSEMBLY_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_DRIVING_ITEM_ID
,      CONTRIBUTE_TO_STEP_QTY
,      OLD_COMPONENT_SEQUENCE_ID
,      OPERATION_SEQ_NUM
FROM MSC.MSC_ST_BOM_COMPONENTS#;

Dependencies

[top of page]

MSC.MSC_ST_BOM_COMPONENTS# references the following:

SchemaMSC
TableMSC_ST_BOM_COMPONENTS
MSC.MSC_ST_BOM_COMPONENTS# is referenced by following:

SchemaAPPS
SynonymMSC_ST_BOM_COMPONENTS