View: MTL_SUBINVENTORIES_TRK_VAL_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_SUBINVENTORIES_TRK_VAL_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
, PROJECT_ID
, TASK_ID
, SUBINVENTORY_USAGE
, LPN_CONTROLLED_FLAG
FROM MTL_SECONDARY_INVENTORIES
WHERE NVL(DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND QUANTITY_TRACKED = 1

Columns