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 |
