[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 |