Test Receivables

Description
Run Test Receivables and other Oracle EBS reports with Blitz Report™ on our demo environment
Select
rct.trx_number,
rctl.*
from
ra_customer_trx_all rct,
ra_customer_trx_lines_all rctl,
hr_all_organization_units_vl haouv,
ra_cust_trx_types_all rctt
where
1=1 and
rct.customer_trx_id=rctl.customer_trx_id and
rct.org_id=haouv.organization_id and
rct.cust_trx_type_id=rctt.cust_trx_type_id
Parameter Name SQL text Validation
Operating Unit
haouv.name=:operating_unit
LOV
Trx Date From
rct.trx_date>=:p_trx_date_from
Date
Trx Date To
rct.trx_date<:p_trx_date_to+1
Date
Blitz Report™