View: PJMFV_ITEM_MODEL_UNIT_NUMS

Product:	PJM - Project Manufacturing
Description:	End Item Model/Unit Numbers
Implementation/DBA Data:	APPS.PJMFV_ITEM_MODEL_UNIT_NUMS

View Text

SELECT PUN.UNIT_NUMBER
, PUN.PREFIX
, PUN.COMMENTS
, '_DF:PJM:PJM_UNIT_NUMBERS:PUN'
, PUN.MASTER_ORGANIZATION_ID
, PUN.END_ITEM_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, '_KF:INV:MSTK:MSI'
, PUN.LAST_UPDATE_DATE
, PUN.LAST_UPDATED_BY
, PUN.CREATION_DATE
, PUN.CREATED_BY
FROM PJM_UNIT_NUMBERS PUN
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE MP.ORGANIZATION_ID = PUN.MASTER_ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = PUN.END_ITEM_ID WITH READ ONLY

Columns