VIEW: MSC.MSC_ST_CO_PRODUCTS#

Source

View Text - Preformatted

select COMPONENT_NAME COMPONENT_NAME, COMPONENT_ID COMPONENT_ID, CO_PRODUCT_NAME CO_PRODUCT_NAME, CO_PRODUCT_ID CO_PRODUCT_ID, SPLIT SPLIT, PRIMARY_FLAG PRIMARY_FLAG, ORGANIZATION_CODE ORGANIZATION_CODE, DELETED_FLAG DELETED_FLAG, SR_INSTANCE_ID SR_INSTANCE_ID, COMPANY_NAME COMPANY_NAME, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, REFRESH_ID REFRESH_ID, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CO_PRODUCT_GROUP_ID CO_PRODUCT_GROUP_ID, SOURCE_COMPONENT_ID SOURCE_COMPONENT_ID, SOURCE_CO_PRODUCT_ID SOURCE_CO_PRODUCT_ID, SOURCE_CO_PRODUCT_GROUP_ID SOURCE_CO_PRODUCT_GROUP_ID from "MSC"."MSC_ST_CO_PRODUCTS"

View Text - HTML Formatted

SELECT COMPONENT_NAME COMPONENT_NAME
, COMPONENT_ID COMPONENT_ID
, CO_PRODUCT_NAME CO_PRODUCT_NAME
, CO_PRODUCT_ID CO_PRODUCT_ID
, SPLIT SPLIT
, PRIMARY_FLAG PRIMARY_FLAG
, ORGANIZATION_CODE ORGANIZATION_CODE
, DELETED_FLAG DELETED_FLAG
, SR_INSTANCE_ID SR_INSTANCE_ID
, COMPANY_NAME COMPANY_NAME
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, REFRESH_ID REFRESH_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CO_PRODUCT_GROUP_ID CO_PRODUCT_GROUP_ID
, SOURCE_COMPONENT_ID SOURCE_COMPONENT_ID
, SOURCE_CO_PRODUCT_ID SOURCE_CO_PRODUCT_ID
, SOURCE_CO_PRODUCT_GROUP_ID SOURCE_CO_PRODUCT_GROUP_ID
FROM "MSC"."MSC_ST_CO_PRODUCTS"