VIEW: BOM.CST_SC_SOURCING_RULES#

Source

View Text - Preformatted

select ROLLUP_ID ROLLUP_ID, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, VENDOR_ID VENDOR_ID, SOURCE_TYPE SOURCE_TYPE, SHIP_METHOD SHIP_METHOD, ALLOCATION_PERCENT ALLOCATION_PERCENT, MARKUP_CODE MARKUP_CODE, MARKUP MARKUP, SHIP_CHARGE_CODE SHIP_CHARGE_CODE, SHIP_CHARGE SHIP_CHARGE, ITEM_COST ITEM_COST, BUY_COST_FLAG BUY_COST_FLAG, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_RATE CONVERSION_RATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, VENDOR_SITE_ID VENDOR_SITE_ID, SOURCING_RULE_NAME SOURCING_RULE_NAME from "BOM"."CST_SC_SOURCING_RULES"

View Text - HTML Formatted

SELECT ROLLUP_ID ROLLUP_ID
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, VENDOR_ID VENDOR_ID
, SOURCE_TYPE SOURCE_TYPE
, SHIP_METHOD SHIP_METHOD
, ALLOCATION_PERCENT ALLOCATION_PERCENT
, MARKUP_CODE MARKUP_CODE
, MARKUP MARKUP
, SHIP_CHARGE_CODE SHIP_CHARGE_CODE
, SHIP_CHARGE SHIP_CHARGE
, ITEM_COST ITEM_COST
, BUY_COST_FLAG BUY_COST_FLAG
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_RATE CONVERSION_RATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, VENDOR_SITE_ID VENDOR_SITE_ID
, SOURCING_RULE_NAME SOURCING_RULE_NAME
FROM "BOM"."CST_SC_SOURCING_RULES"