VIEW: MSD.MSD_ST_PRICE_LIST#

Source

View Text - Preformatted

select INSTANCE INSTANCE, ORGANIZATION_LVL_ID ORGANIZATION_LVL_ID, SR_ORGANIZATION_LVL_PK SR_ORGANIZATION_LVL_PK, PRODUCT_LVL_ID PRODUCT_LVL_ID, SR_PRODUCT_LVL_PK SR_PRODUCT_LVL_PK, SALESCHANNEL_LVL_ID SALESCHANNEL_LVL_ID, SR_SALESCHANNEL_LVL_PK SR_SALESCHANNEL_LVL_PK, SALES_REP_LVL_ID SALES_REP_LVL_ID, SR_SALES_REP_LVL_PK SR_SALES_REP_LVL_PK, GEOGRAPHY_LVL_ID GEOGRAPHY_LVL_ID, SR_GEOGRAPHY_LVL_PK SR_GEOGRAPHY_LVL_PK, USER_DEFINED1_LVL_ID USER_DEFINED1_LVL_ID, SR_USER_DEFINED1_LVL_PK SR_USER_DEFINED1_LVL_PK, USER_DEFINED2_LVL_ID USER_DEFINED2_LVL_ID, SR_USER_DEFINED2_LVL_PK SR_USER_DEFINED2_LVL_PK, PRICE_LIST_NAME PRICE_LIST_NAME, START_DATE START_DATE, END_DATE END_DATE, PRICE PRICE, PRIORITY PRIORITY, 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, ORGANIZATION_LVL ORGANIZATION_LVL, SR_ORGANIZATION_LVL_VAL SR_ORGANIZATION_LVL_VAL, PRODUCT_LVL PRODUCT_LVL, SR_PRODUCT_LVL_VAL SR_PRODUCT_LVL_VAL, SALESCHANNEL_LVL SALESCHANNEL_LVL, SR_SALESCHANNEL_LVL_VAL SR_SALESCHANNEL_LVL_VAL, SALES_REP_LVL SALES_REP_LVL, SR_SALES_REP_LVL_VAL SR_SALES_REP_LVL_VAL, GEOGRAPHY_LVL GEOGRAPHY_LVL, SR_GEOGRAPHY_LVL_VAL SR_GEOGRAPHY_LVL_VAL, USER_DEFINED1_LVL USER_DEFINED1_LVL, SR_USER_DEFINED1_LVL_VAL SR_USER_DEFINED1_LVL_VAL, USER_DEFINED2_LVL USER_DEFINED2_LVL, SR_USER_DEFINED2_LVL_VAL SR_USER_DEFINED2_LVL_VAL, SR_INSTANCE_CODE SR_INSTANCE_CODE, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, DEMAND_CLASS_LVL_ID DEMAND_CLASS_LVL_ID, SR_DEMAND_CLASS_LVL_PK SR_DEMAND_CLASS_LVL_PK, SR_DEMAND_CLASS_LVL_VAL SR_DEMAND_CLASS_LVL_VAL, DEMAND_CLASS_LVL DEMAND_CLASS_LVL, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG, PRICE_LIST_UOM PRICE_LIST_UOM, VALID_FLAG VALID_FLAG from "MSD"."MSD_ST_PRICE_LIST"

View Text - HTML Formatted

SELECT INSTANCE INSTANCE
, ORGANIZATION_LVL_ID ORGANIZATION_LVL_ID
, SR_ORGANIZATION_LVL_PK SR_ORGANIZATION_LVL_PK
, PRODUCT_LVL_ID PRODUCT_LVL_ID
, SR_PRODUCT_LVL_PK SR_PRODUCT_LVL_PK
, SALESCHANNEL_LVL_ID SALESCHANNEL_LVL_ID
, SR_SALESCHANNEL_LVL_PK SR_SALESCHANNEL_LVL_PK
, SALES_REP_LVL_ID SALES_REP_LVL_ID
, SR_SALES_REP_LVL_PK SR_SALES_REP_LVL_PK
, GEOGRAPHY_LVL_ID GEOGRAPHY_LVL_ID
, SR_GEOGRAPHY_LVL_PK SR_GEOGRAPHY_LVL_PK
, USER_DEFINED1_LVL_ID USER_DEFINED1_LVL_ID
, SR_USER_DEFINED1_LVL_PK SR_USER_DEFINED1_LVL_PK
, USER_DEFINED2_LVL_ID USER_DEFINED2_LVL_ID
, SR_USER_DEFINED2_LVL_PK SR_USER_DEFINED2_LVL_PK
, PRICE_LIST_NAME PRICE_LIST_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, PRICE PRICE
, PRIORITY PRIORITY
, 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
, ORGANIZATION_LVL ORGANIZATION_LVL
, SR_ORGANIZATION_LVL_VAL SR_ORGANIZATION_LVL_VAL
, PRODUCT_LVL PRODUCT_LVL
, SR_PRODUCT_LVL_VAL SR_PRODUCT_LVL_VAL
, SALESCHANNEL_LVL SALESCHANNEL_LVL
, SR_SALESCHANNEL_LVL_VAL SR_SALESCHANNEL_LVL_VAL
, SALES_REP_LVL SALES_REP_LVL
, SR_SALES_REP_LVL_VAL SR_SALES_REP_LVL_VAL
, GEOGRAPHY_LVL GEOGRAPHY_LVL
, SR_GEOGRAPHY_LVL_VAL SR_GEOGRAPHY_LVL_VAL
, USER_DEFINED1_LVL USER_DEFINED1_LVL
, SR_USER_DEFINED1_LVL_VAL SR_USER_DEFINED1_LVL_VAL
, USER_DEFINED2_LVL USER_DEFINED2_LVL
, SR_USER_DEFINED2_LVL_VAL SR_USER_DEFINED2_LVL_VAL
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
, DEMAND_CLASS_LVL_ID DEMAND_CLASS_LVL_ID
, SR_DEMAND_CLASS_LVL_PK SR_DEMAND_CLASS_LVL_PK
, SR_DEMAND_CLASS_LVL_VAL SR_DEMAND_CLASS_LVL_VAL
, DEMAND_CLASS_LVL DEMAND_CLASS_LVL
, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG
, PRICE_LIST_UOM PRICE_LIST_UOM
, VALID_FLAG VALID_FLAG
FROM "MSD"."MSD_ST_PRICE_LIST"