DBA Data[Home] [Help]

VIEW: MSC.MSC_TP_ID_LID#

Source

View Text - Preformatted

select SR_TP_ID SR_TP_ID, SR_INSTANCE_ID SR_INSTANCE_ID, PARTNER_TYPE PARTNER_TYPE, TP_ID TP_ID, SR_COMPANY_ID SR_COMPANY_ID, AGGREGATE_DEMAND_FLAG AGGREGATE_DEMAND_FLAG, SR_CUST_ACCOUNT_NUMBER SR_CUST_ACCOUNT_NUMBER, RESOURCE_TYPE RESOURCE_TYPE from "MSC"."MSC_TP_ID_LID"
View Text - HTML Formatted

SELECT SR_TP_ID SR_TP_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, PARTNER_TYPE PARTNER_TYPE
, TP_ID TP_ID
, SR_COMPANY_ID SR_COMPANY_ID
, AGGREGATE_DEMAND_FLAG AGGREGATE_DEMAND_FLAG
, SR_CUST_ACCOUNT_NUMBER SR_CUST_ACCOUNT_NUMBER
, RESOURCE_TYPE RESOURCE_TYPE
FROM "MSC"."MSC_TP_ID_LID"