Payments details

SELECT RCTA.CUSTOMER_TRX_ID,
RCTA.PURCHASE_ORDER,
RCTA.CT_REFERENCE,
RCTA.TRX_NUMBER,
RCTA.BILL_TO_ADDRESS_ID,
RCTA.TRX_DATE,
RCTLA.CUSTOMER_TRX_LINE_ID,
RCTLA.CUSTOMER_TRX_ID,
RCTLA.LINK_TO_CUST_TRX_LINE_ID,
RCTLA.LINE_TYPE,
RCTLA.EXTENDED_AMOUNT,
RCTLGL.CUST_TRX_LINE_GL_DIST_ID,
RCTLGL.CODE_COMBINATION_ID,
RCTLGL.CUSTOMER_TRX_LINE_ID,
RCTLGL.ACCOUNT_CLASS,
RCTLGL.AMOUNT,
APSA.PAYMENT_SCHEDULE_ID,
APSA.AMOUNT_DUE_ORIGINAL,
APSA.AMOUNT_DUE_REMAINING,
APSA.CUSTOMER_TRX_ID,
APSA.CUSTOMER_ID,
APSA.CASH_RECEIPT_ID,
APSA.TRX_NUMBER,
APSA.STATUS,
APSA.AMOUNT_APPLIED,
APSA.CLASS
FROM AR.RA_CUSTOMER_TRX_ALL rcta,
AR.RA_CUSTOMER_TRX_LINES_ALL rctla,
AR.RA_CUST_TRX_LINE_GL_DIST_ALL rctlgl,
AR.AR_PAYMENT_SCHEDULES_ALL apsa
WHERE RCTA.CUSTOMER_TRX_ID = rctla.CUSTOMER_TRX_ID
AND RCTLA.CUSTOMER_TRX_LINE_ID = RCTLGL.CUSTOMER_TRX_LINE_ID
AND APSA.CUSTOMER_TRX_ID = RCTLGL.CUSTOMER_TRX_ID
and rcta.CUSTOMER_TRX_ID=1303933