VIEW: APPS.EDW_ITEMS_ITEM_ORG_FKV

Source

View Text - Preformatted

SELECT msi.inventory_item_id, msi.organization_id, msi.concatenated_segments||'-'||mp.organization_code||'-'||'IORG' from mtl_system_items_kfv msi, mtl_parameters mp WHERE msi.organization_id = mp.organization_id

View Text - HTML Formatted

SELECT MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS||'-'||MP.ORGANIZATION_CODE||'-'||'IORG'
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MP
WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID