View: MTL_ITEM_SUB_EXP_VAL_V

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

View Text

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

Columns