View: MRP_SCATP_SOURCES_V

Product:	MRP - Master Scheduling/MRP
Description:	Supply Chain ATP sources view
Implementation/DBA Data:	APPS.MRP_SCATP_SOURCES_V

View Text

SELECT INVENTORY_ITEM_ID
, TO_LOCATION_ID
, ASSIGNMENT_TYPE
, ASSIGNMENT_SET_ID
, SOURCING_RULE_TYPE
, SOURCE_ORGANIZATION_ID
, FROM_LOCATION_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ALLOCATION_PERCENT
, RANK
, AVG_TRANSIT_LEAD_TIME
, SHIP_METHOD
, EFFECTIVE_DATE
, DISABLE_DATE
, CATEGORY_ID
, ASSIGNMENT_ID
, SOURCING_RULE_ID
, SOURCE_TYPE
, SOURCING_RULE_NAME
, CUSTOMER_ID
, SHIP_TO_SITE_ID
FROM MRP_SCATP_ITEM_SR_LEVELS_V MSISLV
WHERE SOURCING_LEVEL = (SELECT MIN(SOURCING_LEVEL)
FROM MRP_SCATP_ITEM_SR_LEVELS_V MSISLV1
WHERE MSISLV.CUSTOMER_ID = MSISLV1.CUSTOMER_ID
AND MSISLV.SHIP_TO_SITE_ID = MSISLV1.SHIP_TO_SITE_ID
AND MSISLV.INVENTORY_ITEM_ID = MSISLV1.INVENTORY_ITEM_ID
AND MSISLV.ASSIGNMENT_SET_ID = MSISLV1.ASSIGNMENT_SET_ID)

Columns