[Home] [Help]
View: 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
Name |
ITEM_MODEL_UNIT_NUMBER |
PREFIX |
COMMENTS |
"_DF" |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
"_KF:ITEM_NAME" |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |