View: MTL_SUB_TRK_ALL_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_SUB_TRK_ALL_V

View Text

SELECT SECONDARY_INVENTORY_NAME
, ORGANIZATION_ID
, DESCRIPTION
, INVENTORY_ATP_CODE
, AVAILABILITY_TYPE
, RESERVABLE_TYPE
, LOCATOR_TYPE
, PICKING_ORDER
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, QUANTITY_TRACKED
, ASSET_INVENTORY
, SOURCE_TYPE
, SOURCE_SUBINVENTORY
, SOURCE_ORGANIZATION_ID
, REQUISITION_APPROVAL_TYPE
, EXPENSE_ACCOUNT
, ENCUMBRANCE_ACCOUNT
, DISABLE_DATE
, PROJECT_ID
, TASK_ID
, SUBINVENTORY_USAGE
FROM MTL_SECONDARY_INVENTORIES
WHERE QUANTITY_TRACKED = 1
AND (SUBINVENTORY_TYPE = 1 OR SUBINVENTORY_TYPE IS NULL)

Columns