VIEW: APPS.PJMFV_ITEM_MODEL_UNIT_NUMS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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