View: MTL_ITEM_SUB_TRK_ALL_V

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

View Text

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

Columns