[Home] [Help]
2900: l_collectible_bkt_id_tbl,
2901: l_collectible_bkt_amt_tbl
2902: from ar_aging_bucket_lines aabl,
2903: ar_payment_schedules aps,
2904: iex_delinquencies id
2905: where id.payment_schedule_id = aps.payment_schedule_id
2906: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
2907: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
2908: and id.status IN ('DELINQUENT', 'PREDELINQUENT')
2927: WHERE customer_trx_id IN
2928: (SELECT DISTINCT id.transaction_id
2929: FROM ar_aging_bucket_lines aabl,
2930: ar_payment_schedules aps,
2931: iex_delinquencies id
2932: WHERE id.payment_schedule_id = aps.payment_schedule_id
2933: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
2934: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
2935: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to
2951: l_collectible_bkt_id_tbl,
2952: l_collectible_bkt_amt_tbl
2953: from ar_aging_bucket_lines aabl,
2954: ar_payment_schedules aps,
2955: iex_delinquencies id,
2956: hz_cust_accounts hzca
2957: where id.payment_schedule_id = aps.payment_schedule_id
2958: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
2959: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
2987: WHERE customer_trx_id IN
2988: (SELECT DISTINCT id.transaction_id
2989: FROM ar_aging_bucket_lines aabl,
2990: ar_payment_schedules aps,
2991: iex_delinquencies id,
2992: hz_cust_accounts hzca
2993: WHERE id.payment_schedule_id = aps.payment_schedule_id
2994: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
2995: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3020: l_collectible_bkt_id_tbl,
3021: l_collectible_bkt_amt_tbl
3022: from ar_aging_bucket_lines aabl,
3023: ar_payment_schedules aps,
3024: iex_delinquencies id,
3025: hz_cust_accounts hzca
3026: where id.payment_schedule_id = aps.payment_schedule_id
3027: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
3028: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
3048: WHERE customer_trx_id IN
3049: (SELECT DISTINCT id.transaction_id
3050: FROM ar_aging_bucket_lines aabl,
3051: ar_payment_schedules aps,
3052: iex_delinquencies id,
3053: hz_cust_accounts hzca
3054: WHERE id.payment_schedule_id = aps.payment_schedule_id
3055: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
3056: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3074: l_collectible_bkt_id_tbl, -- added by ehuh for bill-to
3075: l_collectible_bkt_amt_tbl -- added by ehuh for bill-to
3076: from ar_aging_bucket_lines aabl, -- added by ehuh for bill-to
3077: ar_payment_schedules aps, -- added by ehuh for bill-to
3078: iex_delinquencies id
3079: where id.payment_schedule_id = aps.payment_schedule_id -- added by ehuh for bill-to
3080: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
3081: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
3082: and id.status IN ('DELINQUENT', 'PREDELINQUENT')
3100: WHERE customer_trx_id IN
3101: (SELECT DISTINCT id.transaction_id
3102: FROM ar_aging_bucket_lines aabl,
3103: ar_payment_schedules aps,
3104: iex_delinquencies id
3105: WHERE id.payment_schedule_id = aps.payment_schedule_id
3106: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
3107: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3108: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to