VIEW: MSC.MSC_ST_COMPONENT_SUBSTITUTES#

Source

View Text - Preformatted

select COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, SUBSTITUTE_ITEM_ID SUBSTITUTE_ITEM_ID, USAGE_QUANTITY USAGE_QUANTITY, ORGANIZATION_ID ORGANIZATION_ID, PRIORITY PRIORITY, 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, BILL_SEQUENCE_ID BILL_SEQUENCE_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, EFFECTIVITY_DATE EFFECTIVITY_DATE, SUB_ITEM_NAME SUB_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, ROUNDING_DIRECTION ROUNDING_DIRECTION from "MSC"."MSC_ST_COMPONENT_SUBSTITUTES"

View Text - HTML Formatted

SELECT COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, SUBSTITUTE_ITEM_ID SUBSTITUTE_ITEM_ID
, USAGE_QUANTITY USAGE_QUANTITY
, ORGANIZATION_ID ORGANIZATION_ID
, PRIORITY PRIORITY
, 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
, BILL_SEQUENCE_ID BILL_SEQUENCE_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
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, SUB_ITEM_NAME SUB_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
, ROUNDING_DIRECTION ROUNDING_DIRECTION
FROM "MSC"."MSC_ST_COMPONENT_SUBSTITUTES"