AR Aging Buckets and Interest Tiers Setup

Description
Categories: Enginatics
Repository: Github
AR Aging Buckets and Interest Tiers Setup
Run AR Aging Buckets and Interest Tiers Setup and other Oracle EBS reports with Blitz Report™ on our demo environment
select
  aab.bucket_name
, aab.aging_bucket_id bucket_id
, xxen_util.meaning(nvl(aab.status,'A'),'ACTIVE_INACTIVE',3) bucket_status
, xxen_util.meaning(aab.aging_type,'AGING_BUCKETS_TYPE',222) bucket_type
, aab.description bucket_description
, aabl.bucket_sequence_num bucket_line_sequence
, xxen_util.meaning(aabl.type,'AGING_BUCKET_LINE_TYPE',222) bucket_line_type
, aabl.days_start
, aabl.days_to
, aabl.report_heading1
, aabl.report_heading2
, aab.creation_date bucket_creation_date
, xxen_util.user_name(aab.created_by) bucket_created_by
, aab.last_update_date bucket_last_updated
, xxen_util.user_name(aab.last_updated_by) bucket_last_updated_by
, aabl.creation_date bucket_line_creation_date
, xxen_util.user_name(aabl.created_by) bucket_line_created_by
, aabl.last_update_date bucket_line_last_updated
, xxen_util.user_name(aabl.last_updated_by) bucket_line_last_updated_by
from
  ar_aging_bucket_lines aabl
, ar_aging_buckets      aab
where
    1=1
and aabl.aging_bucket_id = aab.aging_bucket_id
order by
  aab.bucket_name
, aabl.bucket_sequence_num
Parameter Name SQL text Validation
Bucket Type
aab.aging_type = xxen_util.lookup_code(:p_aging_type,'AGING_BUCKETS_TYPE',222)
LOV
Bucket Name
aab.bucket_name = :p_bucket_name
LOV
Bucket Status
nvl(aab.status,'A') = xxen_util.lookup_code(:p_status,'ACTIVE_INACTIVE',3)
LOV