LCM Script for Accounting transactions that occur for a particular LCM shipment

Hello All,

     I've business need to build query to list all Accounting transactions that occur for a particular LCM shipment and actual Cost Update from LCM Adjustments.

To reconcile LCM accounts especially this account, have balance. This account must have zero balance.

the document (Doc ID 2012856.1) show all event types expect events from 1 to 3.3 as described in the note

I need experts help me to modfying the bellow script to retrive all accounting events and please note that I use actual cost method not average cost

exec mo_global.set_policy_context( 'S',&Org_id);

SELECT DECODE (raet.event_type_name, 'RECEIVE', 1, 'LOGICAL_RECEIVE', 1, 'LDD_COST_ADJ_RCV', 3.1, 'LDD_COST_ADJ_DEL_ASSET', 3.2, 'RETURN_TO_RECEIVING', 6.1, 'RETURN_TO_VENDOR', 6.2) event_type,