View: MSC_SCATP_SOURCES_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SCATP_SOURCES_V

View Text

SELECT INVENTORY_ITEM_ID
, ASSIGNMENT_TYPE
, ASSIGNMENT_SET_ID
, SOURCING_RULE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ALLOCATION_PERCENT
, RANK
, EFFECTIVE_DATE
, DISABLE_DATE
, CATEGORY_ID
, ASSIGNMENT_ID
, SOURCING_RULE_ID
, SOURCE_TYPE
, SOURCING_RULE_NAME
, CUSTOMER_ID
, SHIP_TO_SITE_ID
, REGION_ID
, SESSION_ID
, SOURCING_LEVEL FROM MSC_SCATP_ITEM_SR_LEVELS_V MSISLV
WHERE MSISLV.SOURCING_LEVEL = ( SELECT MIN(MSISLV1.SOURCING_LEVEL) FROM MSC_SCATP_ITEM_SR_LEVELS_V MSISLV1 WHERE MSISLV.SHIP_TO_SITE_ID = MSISLV1.SHIP_TO_SITE_ID AND MSISLV.INVENTORY_ITEM_ID = MSISLV1.INVENTORY_ITEM_ID AND MSISLV.SESSION_ID = MSISLV1.SESSION_ID AND MSISLV.ASSIGNMENT_SET_ID = MSISLV1.ASSIGNMENT_SET_ID)

Columns