Reports2017-11-18T12:27:27+00:00

JL Brazilian Receivables Customer Account Detail - draft

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Brazilian Receivables Customer Account Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLBRRCAD_XML
DB package: JL_JLBRRCAD_XMLP_PKG
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
Parameter Name SQL text Validation
Customer Name To
 
LOV Oracle
Customer Name From
 
LOV Oracle
Customer Number To
 
LOV Oracle
Customer Number From
 
LOV Oracle
Invoice Number To
 
LOV Oracle
Invoice Number From
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept