VIEW: APPS.MTL_ITEM_SUB_EXP_VAL_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)