View: MSC_ITEM_LOWEST_SR_LEVEL_V

Product:	MSC - Advanced Supply Chain Planning
Description:	Lowest sourcing level of an inventory org item
Implementation/DBA Data:	APPS.MSC_ITEM_LOWEST_SR_LEVEL_V

View Text

SELECT MISLV.INVENTORY_ITEM_ID
, MISLV.ORGANIZATION_ID
, MISLV.SR_INSTANCE_ID
, MAS.ASSIGNMENT_SET_ID
, MISLV.SOURCE_ORGANIZATION_ID
, MISLV.SOURCE_ORG_INSTANCE_ID
, MISLV.EFFECTIVE_DATE
, MISLV.DISABLE_DATE
FROM MSC_ITEM_SR_LEVELS_V MISLV
, MSC_ASSIGNMENT_SETS MAS
WHERE MISLV.SOURCING_LEVEL = (SELECT MIN(SOURCING_LEVEL)
FROM MSC_ITEM_SR_LEVELS_V MISLV1
WHERE MISLV.ORGANIZATION_ID = MISLV1.ORGANIZATION_ID
AND MISLV.INVENTORY_ITEM_ID = MISLV1.INVENTORY_ITEM_ID
AND MISLV.SR_INSTANCE_ID = MISLV1.SR_INSTANCE_ID
AND MISLV.ASSIGNMENT_SET_ID = MISLV1.ASSIGNMENT_SET_ID)
AND MAS.ASSIGNMENT_SET_ID = MISLV.ASSIGNMENT_SET_ID

Columns