VIEW: MSC.MSC_ITEM_FCST_BOD_SR_LEVELS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SR_INVENTORY_ITEM_ID SR_INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, PLAN_ID PLAN_ID, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, SOURCING_RULE_TYPE SOURCING_RULE_TYPE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ALLOCATION_PERCENT ALLOCATION_PERCENT, RANK RANK, SHIP_METHOD SHIP_METHOD, EFFECTIVE_DATE EFFECTIVE_DATE, DISABLE_DATE DISABLE_DATE, CATEGORY_ID CATEGORY_ID, SOURCING_LEVEL SOURCING_LEVEL, ASSIGNMENT_ID ASSIGNMENT_ID, SOURCING_RULE_ID SOURCING_RULE_ID, SOURCING_RULE_NAME SOURCING_RULE_NAME, SOURCE_TYPE SOURCE_TYPE, SOURCE_ORG_CODE SOURCE_ORG_CODE, SR_DESCRIPTION SR_DESCRIPTION, OWNING_ORG_ID OWNING_ORG_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, ZONE_ID ZONE_ID from "MSC"."MSC_ITEM_FCST_BOD_SR_LEVELS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SR_INVENTORY_ITEM_ID SR_INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, PLAN_ID PLAN_ID
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, SOURCING_RULE_TYPE SOURCING_RULE_TYPE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ALLOCATION_PERCENT ALLOCATION_PERCENT
, RANK RANK
, SHIP_METHOD SHIP_METHOD
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISABLE_DATE DISABLE_DATE
, CATEGORY_ID CATEGORY_ID
, SOURCING_LEVEL SOURCING_LEVEL
, ASSIGNMENT_ID ASSIGNMENT_ID
, SOURCING_RULE_ID SOURCING_RULE_ID
, SOURCING_RULE_NAME SOURCING_RULE_NAME
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, SR_DESCRIPTION SR_DESCRIPTION
, OWNING_ORG_ID OWNING_ORG_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, ZONE_ID ZONE_ID
FROM "MSC"."MSC_ITEM_FCST_BOD_SR_LEVELS"