View: PJM_UNIT_NUMBERS_LOV_V

Product:	PJM - Project Manufacturing
Description:	End item model/unit number view for List of Values
Implementation/DBA Data:	APPS.PJM_UNIT_NUMBERS_LOV_V

View Text

SELECT PUN.UNIT_NUMBER
, PUN.END_ITEM_ID
, MIF.ITEM_NUMBER
, PUN.MASTER_ORGANIZATION_ID
, PUN.COMMENTS
FROM PJM_UNIT_NUMBERS PUN
, MTL_ITEM_FLEXFIELDS MIF
, MTL_PARAMETERS MP
WHERE MIF.INVENTORY_ITEM_ID = PUN.END_ITEM_ID
AND MIF.ORGANIZATION_ID = PUN.MASTER_ORGANIZATION_ID
AND MP.MASTER_ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = NVL( FND_PROFILE.VALUE('MFG_ORGANIZATION_ID')
, MIF.ORGANIZATION_ID)

Columns