RA_CUSTOMER_TRX is a synonym for RA_CUSTOMER_TRX_ALL however the synonym has a VPD policy applied to it for MOAC.
select * from dba_policies where object_name = 'RA_CUSTOMER_TRX'
To select from VPD secured tables need to initialize your apps context using
with a valid responsibility for your user. That should let you access everything in your table. If you also need to query in a secured manner, you can call
which initializes the security policy.
You need to set org context before fetching from ra_customer_trx
exec MO_GLOBAL.SET_POLICY_CONTEXT('S', &org_id);