Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_SUB_TRK_ALL_V |
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)