[Home] [Help]
2880: l_collectible_bkt_id_tbl,
2881: l_collectible_bkt_amt_tbl
2882: from ar_aging_bucket_lines aabl,
2883: ar_payment_schedules aps,
2884: iex_delinquencies id
2885: where id.payment_schedule_id = aps.payment_schedule_id
2886: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
2887: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
2888: and id.status IN ('DELINQUENT', 'PREDELINQUENT')
2907: WHERE customer_trx_id IN
2908: (SELECT DISTINCT id.transaction_id
2909: FROM ar_aging_bucket_lines aabl,
2910: ar_payment_schedules aps,
2911: iex_delinquencies id
2912: WHERE id.payment_schedule_id = aps.payment_schedule_id
2913: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
2914: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
2915: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to
2931: l_collectible_bkt_id_tbl,
2932: l_collectible_bkt_amt_tbl
2933: from ar_aging_bucket_lines aabl,
2934: ar_payment_schedules aps,
2935: iex_delinquencies id,
2936: hz_cust_accounts hzca
2937: where id.payment_schedule_id = aps.payment_schedule_id
2938: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
2939: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
2967: WHERE customer_trx_id IN
2968: (SELECT DISTINCT id.transaction_id
2969: FROM ar_aging_bucket_lines aabl,
2970: ar_payment_schedules aps,
2971: iex_delinquencies id,
2972: hz_cust_accounts hzca
2973: WHERE id.payment_schedule_id = aps.payment_schedule_id
2974: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
2975: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3000: l_collectible_bkt_id_tbl,
3001: l_collectible_bkt_amt_tbl
3002: from ar_aging_bucket_lines aabl,
3003: ar_payment_schedules aps,
3004: iex_delinquencies id,
3005: hz_cust_accounts hzca
3006: where id.payment_schedule_id = aps.payment_schedule_id
3007: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
3008: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
3028: WHERE customer_trx_id IN
3029: (SELECT DISTINCT id.transaction_id
3030: FROM ar_aging_bucket_lines aabl,
3031: ar_payment_schedules aps,
3032: iex_delinquencies id,
3033: hz_cust_accounts hzca
3034: WHERE id.payment_schedule_id = aps.payment_schedule_id
3035: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
3036: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3054: l_collectible_bkt_id_tbl, -- added by ehuh for bill-to
3055: l_collectible_bkt_amt_tbl -- added by ehuh for bill-to
3056: from ar_aging_bucket_lines aabl, -- added by ehuh for bill-to
3057: ar_payment_schedules aps, -- added by ehuh for bill-to
3058: iex_delinquencies id
3059: where id.payment_schedule_id = aps.payment_schedule_id -- added by ehuh for bill-to
3060: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
3061: -- and id.status IN ('DELINQUENT', 'PRE-DELINQUENT')
3062: and id.status IN ('DELINQUENT', 'PREDELINQUENT')
3080: WHERE customer_trx_id IN
3081: (SELECT DISTINCT id.transaction_id
3082: FROM ar_aging_bucket_lines aabl,
3083: ar_payment_schedules aps,
3084: iex_delinquencies id
3085: WHERE id.payment_schedule_id = aps.payment_schedule_id
3086: AND id.status IN('DELINQUENT', 'PREDELINQUENT')
3087: AND TRUNC(sysdate) -aps.due_date >= aabl.days_start
3088: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to