ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN D168B1A4009B4EDDE05362FB090596DB 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 Y US AR Aging Buckets and Interest Tiers Setup AR Aging Buckets and Interest Tiers Setup Enginatics 1=1 1 10 1=1 aab.aging_type = xxen_util.lookup_code(:p_aging_type,'AGING_BUCKETS_TYPE',222) LOV custom select meaning value ,null description from fnd_lookup_values_vl where lookup_type='AGING_BUCKETS_TYPE' and view_application_id=222 order by meaning F Type de seau US Bucket Type 2 20 1=1 aab.bucket_name = :p_bucket_name LOV custom Y select aab.bucket_name value, aab.description description from ar_aging_buckets aab where (:$flex$.Bucket_Type is null or xxen_util.meaning(aab.aging_type,'AGING_BUCKETS_TYPE',222) = :$flex$.Bucket_Type ) order by aab.bucket_name F Nom du seau US Bucket Name 3 30 1=1 nvl(aab.status,'A') = xxen_util.lookup_code(:p_status,'ACTIVE_INACTIVE',3) LOV custom Y select meaning value ,null description from fnd_lookup_values_vl where lookup_type = 'ACTIVE_INACTIVE' and view_application_id = 3 order by meaning F État du godet US Bucket Status :$flex$.Bucket_Type Bucket Type Bucket Name