[Home] [Help]
View: PA_ITEMS_RES_V
View Text
SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.DESCRIPTION
, ITEMS.ORGANIZATION_ID
, ORG.NAME
FROM MTL_SYSTEM_ITEMS ITEMS
, HR_ALL_ORGANIZATION_UNITS_VL ORG
WHERE ORG.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
Columns
Name |
ITEM_ID |
DESCRIPTION |
ORGANIZATION_ID |
ORGANIZATION_NAME |