VIEW: APPS.OPI_SUBINVENTORIES_V

Source

View Text - Preformatted

SELECT (msi.secondary_inventory_name||'-'||msi.organization_id) id, msi.secondary_inventory_name || '(' || mp.organization_code || ')' value, msi.description description, msi.secondary_inventory_name subinventory_code, msi.organization_id organization_id, msi.asset_inventory asset_inventory FROM mtl_secondary_inventories msi, mtl_parameters mp WHERE mp.organization_id = msi.organization_id UNION ALL SELECT fnd_lv.lookup_code, fnd_lv.meaning value, fnd_lv.description, NULL subinventory_code, NULL organization_id, NULL asset_inventory FROM fnd_lookups fnd_lv WHERE fnd_lv.lookup_type = 'OPI_DBI_SUBINV' AND fnd_lv.lookup_code = '-1'

View Text - HTML Formatted

SELECT (MSI.SECONDARY_INVENTORY_NAME||'-'||MSI.ORGANIZATION_ID) ID
, MSI.SECONDARY_INVENTORY_NAME || '(' || MP.ORGANIZATION_CODE || ')' VALUE
, MSI.DESCRIPTION DESCRIPTION
, MSI.SECONDARY_INVENTORY_NAME SUBINVENTORY_CODE
, MSI.ORGANIZATION_ID ORGANIZATION_ID
, MSI.ASSET_INVENTORY ASSET_INVENTORY
FROM MTL_SECONDARY_INVENTORIES MSI
, MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID UNION ALL SELECT FND_LV.LOOKUP_CODE
, FND_LV.MEANING VALUE
, FND_LV.DESCRIPTION
, NULL SUBINVENTORY_CODE
, NULL ORGANIZATION_ID
, NULL ASSET_INVENTORY
FROM FND_LOOKUPS FND_LV
WHERE FND_LV.LOOKUP_TYPE = 'OPI_DBI_SUBINV'
AND FND_LV.LOOKUP_CODE = '-1'