VIEW: MSC.MSC_ST_ITEM_SUBSTITUTES#

Source

View Text - Preformatted

select SR_INSTANCE_ID SR_INSTANCE_ID, LOWER_ITEM_ID LOWER_ITEM_ID, HIGHER_ITEM_ID HIGHER_ITEM_ID, HIGHEST_ITEM_ID HIGHEST_ITEM_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, EFFECTIVE_DATE EFFECTIVE_DATE, DISABLE_DATE DISABLE_DATE, RELATIONSHIP_TYPE RELATIONSHIP_TYPE, RECIPROCAL_FLAG RECIPROCAL_FLAG, SUBSTITUTION_SET SUBSTITUTION_SET, PARTIAL_FULFILLMENT_FLAG PARTIAL_FULFILLMENT_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SUBSTITUTE_ITEM_NAME SUBSTITUTE_ITEM_NAME, ITEM_NAME ITEM_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, BATCH_ID BATCH_ID, DELETED_FLAG DELETED_FLAG, COMPANY_NAME COMPANY_NAME, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORGANIZATION_ID ORGANIZATION_ID, REFRESH_ID REFRESH_ID, ORGANIZATION_CODE ORGANIZATION_CODE from "MSC"."MSC_ST_ITEM_SUBSTITUTES"

View Text - HTML Formatted

SELECT SR_INSTANCE_ID SR_INSTANCE_ID
, LOWER_ITEM_ID LOWER_ITEM_ID
, HIGHER_ITEM_ID HIGHER_ITEM_ID
, HIGHEST_ITEM_ID HIGHEST_ITEM_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISABLE_DATE DISABLE_DATE
, RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, RECIPROCAL_FLAG RECIPROCAL_FLAG
, SUBSTITUTION_SET SUBSTITUTION_SET
, PARTIAL_FULFILLMENT_FLAG PARTIAL_FULFILLMENT_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SUBSTITUTE_ITEM_NAME SUBSTITUTE_ITEM_NAME
, ITEM_NAME ITEM_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, BATCH_ID BATCH_ID
, DELETED_FLAG DELETED_FLAG
, COMPANY_NAME COMPANY_NAME
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, REFRESH_ID REFRESH_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
FROM "MSC"."MSC_ST_ITEM_SUBSTITUTES"