SELECT SECONDARY_INVENTORY_NAME SUBINVENTORY, ORGANIZATION_ID SUBINV_ORGANIZATION_ID, LOCATOR_TYPE LOCATOR_TYPE, Decode(Asset_inventory, 1,'Y', 'N' ) ASSET_INVENTORY, SUBINVENTORY_TYPE SUBINVENTORY_TYPE FROM MTL_SECONDARY_INVENTORIES
SELECT SECONDARY_INVENTORY_NAME SUBINVENTORY
, ORGANIZATION_ID SUBINV_ORGANIZATION_ID
, LOCATOR_TYPE LOCATOR_TYPE
, DECODE(ASSET_INVENTORY
, 1
, 'Y'
, 'N' ) ASSET_INVENTORY
, SUBINVENTORY_TYPE SUBINVENTORY_TYPE
FROM MTL_SECONDARY_INVENTORIES
|
|
|