AR Adjustment Register

Description
Categories: Enginatics
Repository: Github
Application: Receivables
Source: Adjustment Register
Short Name: ARRXARPB

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
  rx.organization_name ledger,
  rx.functional_currency_code functional_currency,
  rx.debit_balancing "&bal_segment_p",
  rx.debit_balancing_desc "&bal_segment_d",
  rx.postable,
  rx.adj_currency_code currency,
  rx.adj_class adjustment_class,
  rx.trx_number invoice_number,
  rx.adj_name "Type",
  rx.customer_name,
  rx.customer_number,
  rx.trx_date invoice_date,
  rx.gl_date,
  rx.due_date,
  rx.adj_number adjustment_number,
  rx.adj_type_meaning adjustment_type,
  rx.adj_amount entered_adjustment_amount,
  rx.acctd_adj_amount functional_adjustment_amount,
  rx.d_or_i "D/I",
  rx.doc_sequence_name,
  rx.doc_sequence_value
from
  ar_adjustments_rep_itf rx
where
  rx.request_id = fnd_global.conc_request_id
order by
  rx.organization_name,
  rx.functional_currency_code,
  rx.debit_balancing,
  rx.postable,
  rx.adj_currency_code,
  rx.adj_class,
  rx.customer_name
Parameter Name SQL text Validation
Reporting Level
 
LOV Oracle
Reporting Context
 
LOV Oracle
Company Segment Low
 
LOV
Company Segment High
 
LOV
GL Date From
 
Date
GL Date To
 
Date
Entered Currency Low
 
LOV Oracle
Entered Currency High
 
LOV Oracle
Transaction Date Low
 
Date
Transaction Date High
 
Date
Transaction Due Date Low
 
Date
Transaction Due Date High
 
Date
Transaction Type Low
 
LOV Oracle
Transaction Type High
 
LOV Oracle
Adjustment Type Low
 
LOV Oracle
Adjustment Type High
 
LOV Oracle
Document Sequence Name
 
LOV Oracle
Document Sequence Number From
 
LOV Oracle
Document Sequence Number To
 
LOV Oracle