VIEW: APPS.MRP_SOURCES_V

Source

View Text - Preformatted

SELECT MISLV. INVENTORY_ITEM_ID , MISLV.ORGANIZATION_ID , MISLV.ASSIGNMENT_TYPE , MAS.ASSIGNMENT_SET_ID , MISLV.SOURCING_RULE_TYPE , MISLV.SOURCE_ORGANIZATION_ID , MISLV.VENDOR_ID , MISLV.VENDOR_SITE_ID , MISLV.ALLOCATION_PERCENT , MISLV.RANK , MISLV.AVG_TRANSIT_LEAD_TIME , MISLV.SHIP_METHOD , MISLV.EFFECTIVE_DATE , MISLV.DISABLE_DATE , MISLV.CATEGORY_ID , MISLV.ASSIGNMENT_ID , MISLV.SOURCING_RULE_ID , MISLV.SOURCE_TYPE , MISLV.SOURCING_RULE_NAME , MISLV.CUSTOMER_ID , MISLV.SHIP_TO_SITE_ID , MISLV.TIME_UOM_CODE FROM MRP_ITEM_SOURCING_LEVELS_V MISLV, MRP_ASSIGNMENT_SETS MAS WHERE MISLV.SOURCING_LEVEL = (SELECT MIN(SOURCING_LEVEL) FROM MRP_ITEM_SOURCING_LEVELS_V MISLV1 WHERE MISLV.ORGANIZATION_ID = MISLV1.ORGANIZATION_ID AND MISLV.INVENTORY_ITEM_ID = MISLV1.INVENTORY_ITEM_ID AND MAS.ASSIGNMENT_SET_ID = MISLV1.ASSIGNMENT_SET_ID ) AND MAS.ASSIGNMENT_SET_ID = MISLV.ASSIGNMENT_SET_ID

View Text - HTML Formatted

SELECT MISLV. INVENTORY_ITEM_ID
, MISLV.ORGANIZATION_ID
, MISLV.ASSIGNMENT_TYPE
, MAS.ASSIGNMENT_SET_ID
, MISLV.SOURCING_RULE_TYPE
, MISLV.SOURCE_ORGANIZATION_ID
, MISLV.VENDOR_ID
, MISLV.VENDOR_SITE_ID
, MISLV.ALLOCATION_PERCENT
, MISLV.RANK
, MISLV.AVG_TRANSIT_LEAD_TIME
, MISLV.SHIP_METHOD
, MISLV.EFFECTIVE_DATE
, MISLV.DISABLE_DATE
, MISLV.CATEGORY_ID
, MISLV.ASSIGNMENT_ID
, MISLV.SOURCING_RULE_ID
, MISLV.SOURCE_TYPE
, MISLV.SOURCING_RULE_NAME
, MISLV.CUSTOMER_ID
, MISLV.SHIP_TO_SITE_ID
, MISLV.TIME_UOM_CODE
FROM MRP_ITEM_SOURCING_LEVELS_V MISLV
, MRP_ASSIGNMENT_SETS MAS
WHERE MISLV.SOURCING_LEVEL = (SELECT MIN(SOURCING_LEVEL)
FROM MRP_ITEM_SOURCING_LEVELS_V MISLV1
WHERE MISLV.ORGANIZATION_ID = MISLV1.ORGANIZATION_ID
AND MISLV.INVENTORY_ITEM_ID = MISLV1.INVENTORY_ITEM_ID
AND MAS.ASSIGNMENT_SET_ID = MISLV1.ASSIGNMENT_SET_ID )
AND MAS.ASSIGNMENT_SET_ID = MISLV.ASSIGNMENT_SET_ID