VIEW: APPS.PJM_UNIT_NUMBERS_LOV_V

Source

View Text - Preformatted

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 WHERE MIF.INVENTORY_ITEM_ID = PUN.END_ITEM_ID AND MIF.ORGANIZATION_ID = PUN.MASTER_ORGANIZATION_ID AND MIF.ORGANIZATION_ID = decode( (select FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') from dual), null, (select FND_PROFILE.VALUE('ORG_ID')from dual), (SELECT MASTER_ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') ) )

View Text - HTML Formatted

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
WHERE MIF.INVENTORY_ITEM_ID = PUN.END_ITEM_ID
AND MIF.ORGANIZATION_ID = PUN.MASTER_ORGANIZATION_ID
AND MIF.ORGANIZATION_ID = DECODE( (SELECT FND_PROFILE.VALUE('MFG_ORGANIZATION_ID')
FROM DUAL)
, NULL
, (SELECT FND_PROFILE.VALUE('ORG_ID')FROM DUAL)
, (SELECT MASTER_ORGANIZATION_ID
FROM MTL_PARAMETERS
WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('MFG_ORGANIZATION_ID') ) )