[Home] [Help]
View: CST_XLA_INV_SEC_INVS_REF_V
View Text
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
Columns
| Name |
| SUBINVENTORY |
| SUBINV_ORGANIZATION_ID |
| LOCATOR_TYPE |
| ASSET_INVENTORY |
| SUBINVENTORY_TYPE |