DBA Data[Home] [Help]

VIEW: APPS.CST_XLA_INV_SEC_INVS_REF_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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