Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_SUB_EXP_VAL_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
, PROJECT_ID
, TASK_ID
, SUBINVENTORY_USAGE
FROM MTL_SECONDARY_INVENTORIES
WHERE NVL(DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND ASSET_INVENTORY = 2
AND (SUBINVENTORY_TYPE = 1 OR SUBINVENTORY_TYPE IS NULL)