VIEW: APPS.MRP_ITEM_LOWEST_SR_LEVEL_V

Source

View Text - Preformatted

SELECT MISLV.INVENTORY_ITEM_ID , MISLV.ORGANIZATION_ID , MISLV.ASSIGNMENT_SET_ID, MISLV.SOURCE_ORGANIZATION_ID, MISLV.EFFECTIVE_DATE , MISLV.DISABLE_DATE FROM MRP_ITEM_SR_LEVELS_V MISLV, MRP_ASSIGNMENT_SETS MAS WHERE MISLV.SOURCING_LEVEL = ( SELECT MIN(sourcing_level) FROM MRP_ITEM_SR_LEVELS_V MISLV2 WHERE MISLV.organization_id = MISLV2.organization_id AND MISLV.inventory_item_id = MISLV2.inventory_item_id AND MISLV.assignment_set_id = MISLV2.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_SET_ID
, MISLV.SOURCE_ORGANIZATION_ID
, MISLV.EFFECTIVE_DATE
, MISLV.DISABLE_DATE
FROM MRP_ITEM_SR_LEVELS_V MISLV
, MRP_ASSIGNMENT_SETS MAS
WHERE MISLV.SOURCING_LEVEL = ( SELECT MIN(SOURCING_LEVEL)
FROM MRP_ITEM_SR_LEVELS_V MISLV2
WHERE MISLV.ORGANIZATION_ID = MISLV2.ORGANIZATION_ID
AND MISLV.INVENTORY_ITEM_ID = MISLV2.INVENTORY_ITEM_ID
AND MISLV.ASSIGNMENT_SET_ID = MISLV2.ASSIGNMENT_SET_ID)
AND MAS.ASSIGNMENT_SET_ID = MISLV.ASSIGNMENT_SET_ID