VIEW: MSC.MSC_ST_DESIGNATORS#

Source

View Text - Preformatted

select DESIGNATOR_ID DESIGNATOR_ID, DESIGNATOR DESIGNATOR, SR_DESIGNATOR SR_DESIGNATOR, ORGANIZATION_ID ORGANIZATION_ID, SR_ORGANIZATION_ID SR_ORGANIZATION_ID, MPS_RELIEF MPS_RELIEF, INVENTORY_ATP_FLAG INVENTORY_ATP_FLAG, DESCRIPTION DESCRIPTION, DISABLE_DATE DISABLE_DATE, DEMAND_CLASS DEMAND_CLASS, ORGANIZATION_SELECTION ORGANIZATION_SELECTION, PRODUCTION PRODUCTION, RECOMMENDATION_RELEASE RECOMMENDATION_RELEASE, DESIGNATOR_TYPE DESIGNATOR_TYPE, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, CONSUME_FORECAST CONSUME_FORECAST, UPDATE_TYPE UPDATE_TYPE, FORWARD_UPDATE_TIME_FENCE FORWARD_UPDATE_TIME_FENCE, BACKWARD_UPDATE_TIME_FENCE BACKWARD_UPDATE_TIME_FENCE, OUTLIER_UPDATE_PERCENTAGE OUTLIER_UPDATE_PERCENTAGE, FORECAST_SET_ID FORECAST_SET_ID, CUSTOMER_ID CUSTOMER_ID, SHIP_ID SHIP_ID, BILL_ID BILL_ID, BUCKET_TYPE BUCKET_TYPE, PROBABILITY PROBABILITY, FORECAST_SET FORECAST_SET, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, CUSTOMER_NAME CUSTOMER_NAME, SHIP_TO_SITE_CODE SHIP_TO_SITE_CODE, BILL_TO_SITE_CODE BILL_TO_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, SELLER_FLAG SELLER_FLAG, SRC_DESCRIPTION SRC_DESCRIPTION, SRC_DESIGNATOR SRC_DESIGNATOR, SRC_SIM_FCST_ID SRC_SIM_FCST_ID from "MSC"."MSC_ST_DESIGNATORS"

View Text - HTML Formatted

SELECT DESIGNATOR_ID DESIGNATOR_ID
, DESIGNATOR DESIGNATOR
, SR_DESIGNATOR SR_DESIGNATOR
, ORGANIZATION_ID ORGANIZATION_ID
, SR_ORGANIZATION_ID SR_ORGANIZATION_ID
, MPS_RELIEF MPS_RELIEF
, INVENTORY_ATP_FLAG INVENTORY_ATP_FLAG
, DESCRIPTION DESCRIPTION
, DISABLE_DATE DISABLE_DATE
, DEMAND_CLASS DEMAND_CLASS
, ORGANIZATION_SELECTION ORGANIZATION_SELECTION
, PRODUCTION PRODUCTION
, RECOMMENDATION_RELEASE RECOMMENDATION_RELEASE
, DESIGNATOR_TYPE DESIGNATOR_TYPE
, DELETED_FLAG DELETED_FLAG
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, CONSUME_FORECAST CONSUME_FORECAST
, UPDATE_TYPE UPDATE_TYPE
, FORWARD_UPDATE_TIME_FENCE FORWARD_UPDATE_TIME_FENCE
, BACKWARD_UPDATE_TIME_FENCE BACKWARD_UPDATE_TIME_FENCE
, OUTLIER_UPDATE_PERCENTAGE OUTLIER_UPDATE_PERCENTAGE
, FORECAST_SET_ID FORECAST_SET_ID
, CUSTOMER_ID CUSTOMER_ID
, SHIP_ID SHIP_ID
, BILL_ID BILL_ID
, BUCKET_TYPE BUCKET_TYPE
, PROBABILITY PROBABILITY
, FORECAST_SET FORECAST_SET
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, CUSTOMER_NAME CUSTOMER_NAME
, SHIP_TO_SITE_CODE SHIP_TO_SITE_CODE
, BILL_TO_SITE_CODE BILL_TO_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
, SELLER_FLAG SELLER_FLAG
, SRC_DESCRIPTION SRC_DESCRIPTION
, SRC_DESIGNATOR SRC_DESIGNATOR
, SRC_SIM_FCST_ID SRC_SIM_FCST_ID
FROM "MSC"."MSC_ST_DESIGNATORS"