select TRANSACTION_ID TRANSACTION_ID, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID, ALTERNATE_COMPONENT_ID ALTERNATE_COMPONENT_ID, RANK RANK, OP_SEQ_NUM OP_SEQ_NUM, RATIO RATIO, PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, 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, REFRESH_ID REFRESH_ID from "MSC"."MSC_WO_SUB_COMP"
SELECT TRANSACTION_ID TRANSACTION_ID
, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID
, ALTERNATE_COMPONENT_ID ALTERNATE_COMPONENT_ID
, RANK RANK
, OP_SEQ_NUM OP_SEQ_NUM
, RATIO RATIO
, PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, 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
, REFRESH_ID REFRESH_ID
FROM "MSC"."MSC_WO_SUB_COMP"
|
|
|