VIEW: MRP.MRP_ITEM_SOURCING#

Source

View Text - Preformatted

select COMPILE_DESIGNATOR COMPILE_DESIGNATOR, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, EFFECTIVE_DATE EFFECTIVE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DISABLE_DATE DISABLE_DATE, ALLOCATION_PERCENT ALLOCATION_PERCENT, RANK RANK, QUANTITY QUANTITY, SOURCE_TYPE SOURCE_TYPE, AVG_TRANSIT_LEAD_TIME AVG_TRANSIT_LEAD_TIME, SOURCING_RULE_ID SOURCING_RULE_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, SOURCING_RULE_TYPE SOURCING_RULE_TYPE, SHIP_METHOD SHIP_METHOD, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HISTORICAL_ALLOC_QTY HISTORICAL_ALLOC_QTY from "MRP"."MRP_ITEM_SOURCING"

View Text - HTML Formatted

SELECT COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DISABLE_DATE DISABLE_DATE
, ALLOCATION_PERCENT ALLOCATION_PERCENT
, RANK RANK
, QUANTITY QUANTITY
, SOURCE_TYPE SOURCE_TYPE
, AVG_TRANSIT_LEAD_TIME AVG_TRANSIT_LEAD_TIME
, SOURCING_RULE_ID SOURCING_RULE_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, SOURCING_RULE_TYPE SOURCING_RULE_TYPE
, SHIP_METHOD SHIP_METHOD
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HISTORICAL_ALLOC_QTY HISTORICAL_ALLOC_QTY
FROM "MRP"."MRP_ITEM_SOURCING"