DBA Data[Home] [Help]

VIEW: MSC.MSC_SUPPLIER_LT_OUTCOMES#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, PLAN_ID PLAN_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SR_INSTANCE_ID2 SR_INSTANCE_ID2, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LATENESS LATENESS, PROBABILITY PROBABILITY, 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, LEADTIME_VARIABILITY LEADTIME_VARIABILITY from "MSC"."MSC_SUPPLIER_LT_OUTCOMES"
View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, PLAN_ID PLAN_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SR_INSTANCE_ID2 SR_INSTANCE_ID2
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LATENESS LATENESS
, PROBABILITY PROBABILITY
, 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
, LEADTIME_VARIABILITY LEADTIME_VARIABILITY
FROM "MSC"."MSC_SUPPLIER_LT_OUTCOMES"