15857154 : 12.0.: Invalid View MTL_AVAILABLE_INVENTORY_V

 Hi IBM-AoD :This thread will address your following issue - 

While applying patch 15857154, we got following error-

Comparing objects in username INV with ODF file
/u013/app/applmgr/DAKAAD3/appltop/inv/12.0.0/patch/115/odf/invmaiv.odf


Reading objects from ODF file

Reading view MTL_AVAILABLE_INVENTORY_V ...

*** Reading views from APPS schema

Reading view MTL_AVAILABLE_INVENTORY_V ...

*******************************************************
The definition of the view MTL_AVAILABLE_INVENTORY_V is incorrect.
The view text is incorrectly defined as:

CREATE OR REPLACE FORCE VIEW APPS.MTL_AVAILABLE_INVENTORY_V ("LOCATOR_ID", "LOT_NUMBER", "SUBINVENTORY_CODE", "CONCATENATED_SEGMENTS", "CREATION_DATE", "EXPIRATION_DATE", "GRADE_CODE", "TRANSACTION_TEMP_ID", "REASON_ID", "REASON_NAME", "TRANS_QTY", "TRANS_QTY2", "TRANSACTION_UOM", "SECONDARY_UOM", "REVISION", "LPN_ID", "ORDER_BY", "WMS_RULE_ID") AS SELECT pklt.locator_id ,lot.lot_number ,pklt.subinventory_code ,inv_project.get_locator(pklt.locator_id,pklt.organization_id) ,lot.creation_date ,lot.expiration_date ,pklt.grade_code ,pklt.transaction_temp_id ,pklt.reason_id ,rsn.reason_name ,decode(pklt.transaction_temp_id, 0, 0, sum(transaction_qty)) trans_qty ,decode(pklt.transaction_temp_id, 0, 0, sum(secondary_transaction_qty)) trans_qty2 ,pklt.transaction_uom ,pklt.secondary_uom ,pklt.revision ,pklt.lpn_id ,pklt.order_by ,pklt.wms_rule_id FROM mtl_available_inventory_temp pklt ,mtl_lot_numbers lot ,mtl_item_locations_kfv loct ,mtl_transaction_reasons rsn WHERE pklt.lot_number = lot.lot_number (+) AND pklt.locator_id = loct.inventory_location_id(+) AND pklt.reason_id = rsn.reason_id(+) AND pklt.inventory_item_id = lot.inventory_item_id(+) AND pklt.organization_id = lot.organization_id(+) GROUP BY pklt.locator_id ,lot.lot_number ,pklt.subinventory_code ,inv_project.get_locator(pklt.locator_id,pklt.organization_id) ,lot.creation_date,lot.expiration_date ,pklt.grade_code ,pklt.transaction_temp_id ,pklt.reason_id ,rsn.reason_name ,pklt.transaction_uom ,pklt.secondary_uom ,pklt.revision ,pklt.lpn_id ,pklt.order_by ,pklt.wms_rule_id ORDER