org_id is blank in transaction type table

select 8 from

ra_customer_trx_all rcta ,
AR_PAYMENT_SCHEDULES_ALL aps ,
RA_CUST_TRX_TYPES_ALL rctt
WHERE
rcta.customer_trx_id = aps.customer_trx_id
AND rcta.CUST_TRX_TYPE_SEQ_ID = rctt.CUST_TRX_TYPE_SEQ_ID
AND rcta.org_id = rctt.org_id

we have this query but it give blank after debugging we found that the org id is blank in the

RA_CUST_TRX_TYPES_ALL is this possible

.