[Home] [Help]
VIEW: APPS.PA_ITEMS_RES_V
Source
View Text - Preformatted
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
View Text - HTML Formatted
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