63: where transaction_id = i_txn_id;
64:
65: select decode(inventory_asset_flag,'Y', 0, 1)
66: into l_exp_item_flag
67: from mtl_system_items
68: where inventory_item_id = i_inv_item_id
69: and organization_id = l_org_id;
70:
71: begin
551: where mmt.transaction_id = i_txn_id;
552:
553: select decode(inventory_asset_flag,'Y', 0, 1)
554: into l_exp_item_flag
555: from mtl_system_items
556: where inventory_item_id = l_item_id
557: and organization_id = l_org_id;
558:
559: -- clear the temp_relieved_value column