VIEW: MSC.MSC_BOM_COMPONENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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