VIEW: MSC.MSC_ST_BOM_COMPONENTS#

Source

View Text - Preformatted

select COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, USING_ASSEMBLY_ID USING_ASSEMBLY_ID, BILL_SEQUENCE_ID BILL_SEQUENCE_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, REVISED_ITEM_SEQUENCE_ID REVISED_ITEM_SEQUENCE_ID, STATUS_TYPE STATUS_TYPE, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, BOM_NAME BOM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, ASSEMBLY_NAME ASSEMBLY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, COMPONENT_NAME COMPONENT_NAME, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, DRIVING_ITEM_NAME DRIVING_ITEM_NAME, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, SCALE_MULTIPLE SCALE_MULTIPLE, SCALE_ROUNDING_VARIANCE SCALE_ROUNDING_VARIANCE, ROUNDING_DIRECTION ROUNDING_DIRECTION, PRIMARY_FLAG PRIMARY_FLAG, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_BILL_SEQUENCE_ID SOURCE_BILL_SEQUENCE_ID, SOURCE_COMPONENT_SEQUENCE_ID SOURCE_COMPONENT_SEQUENCE_ID, SOURCE_USING_ASSEMBLY_ID SOURCE_USING_ASSEMBLY_ID, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID, SOURCE_DRIVING_ITEM_ID SOURCE_DRIVING_ITEM_ID, CONTRIBUTE_TO_STEP_QTY CONTRIBUTE_TO_STEP_QTY, OLD_COMPONENT_SEQUENCE_ID OLD_COMPONENT_SEQUENCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM from "MSC"."MSC_ST_BOM_COMPONENTS"

View Text - HTML Formatted

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