ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1663869E053B46B63588994 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 Y JL JLBRRCAD_XML US JL Brazilian Receivables Customer Account Detail - draft 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 BI Publisher &c_end_cust_name_predicate &c_end_cust_number_predicate &c_end_inv_number_predicate &c_start_cust_name_predicate &c_start_cust_number_predicate &c_start_inv_number_predicate :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_end_cust_name_predicate :c_end_cust_number_predicate :c_end_inv_number_predicate :c_name :c_organisation_name :c_start_cust_name_predicate :c_start_cust_number_predicate :c_start_inv_number_predicate :h_calendar :h_days_late :h_nonworkday :operating_unit :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_end_of_report :p_invoice_number_high :p_invoice_number_low :p_no_data_found 1 10 :p_invoice_number_low LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id US Invoice Number From 2 20 :p_invoice_number_high LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id US Invoice Number To 3 30 :p_customer_number_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Number From 4 40 :p_customer_number_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Number To 5 50 :p_customer_name_low LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name US Customer Name From 6 60 :p_customer_name_high LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name US Customer Name To