JL Brazilian Receivables Customer Account Detail - draft

SELECT   ps.customer_trx_id c_customer_trx_id,
                ps.payment_schedule_id c_payment_schedule_id,
                ps.trx_number c_transaction_number,
                ps.status c_status,
                ps.trx_date c_date,
                ps.due_date c_due_date,
                trx.name c_type,
                ps.class c_class,
                ps.amount_due_original c_original_amount,
                ps.amount_due_remaining c_balance_due,
                cust.account_number c_customer_number,
                pty.party_name c_customer_name,
                ps.global_attribute9 c_global_attribute9,
                ps.selected_for_receipt_batch_id selected_for_receipt_batch_id, 
	JL_JLBRRCAD_XMLP_PKG.c_document_statusformula(ps.selected_for_receipt_batch_id, ps.payment_schedule_id) C_document_status, 
	JL_JLBRRCAD_XMLP_PKG.c_bordero_numberformula(ps.selected_for_receipt_batch_id, ps.payment_schedule_id) C_bordero_number, 
	JL_JLBRRCAD_XMLP_PKG.c_bearer_of_trade_noteformula(ps.global_attribute9) C_bearer_of_trade_note, 
	JL_JLBRRCAD_XMLP_PKG.c_selection_numberformula(ps.selected_for_receipt_batch_id, ps.payment_schedule_id) C_selection_number, 
	JL_JLBRRCAD_XMLP_PKG.cf_int_calformula(ps.customer_trx_id, ps.due_date, ps.amount_due_remaining, ps.payment_schedule_id) CF_Int_Cal, 
	JL_JLBRRCAD_XMLP_PKG.cf_status_meaningformula(ps.status) CF_status_meaning, 
	JL_JLBRRCAD_XMLP_PKG.cf_class_meaningformula(ps.class) CF_CLASS_MEANING,
	JL_JLBRRCAD_XMLP_PKG.H_DAYS_LATE_p H_DAYS_LATE,
	'X' dummy,
	'X' dummy1
FROM      ar_payment_schedules ps,
                ra_cust_trx_types trx,
                hz_cust_accounts cust,
                hz_parties pty
WHERE    ps.status = 'OP'
AND         ps.customer_id = cust.cust_account_id
AND         cust.party_id = pty.party_id
AND         trx.cust_trx_type_id = ps.cust_trx_type_id
&C_Start_Cust_Number_Predicate      
&C_Start_Cust_Name_Predicate
&C_End_Cust_Number_Predicate       
&C_End_Cust_Name_Predicate
&C_Start_Inv_Number_Predicate         
&C_End_Inv_Number_Predicate
ORDER BY 11 ASC,12 ASC