Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_SUBINVENTORIES_ALL_V |
SELECT SECONDARY_INVENTORY_NAME
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, DISABLE_DATE
, 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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PREPROCESSING_LEAD_TIME
, PROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME
, DEMAND_CLASS
, PROJECT_ID
, TASK_ID
, SUBINVENTORY_USAGE
, DEFAULT_COST_GROUP_ID
, LPN_CONTROLLED_FLAG
FROM MTL_SECONDARY_INVENTORIES
WHERE SUBINVENTORY_TYPE = 1 OR SUBINVENTORY_TYPE IS NULL