eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_AGING_BUCKETS_PKG dependencies on RA_CUSTOMER_TRX

Line 3529: b_interface_attr RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE9%TYPE;

3525:
3526: -- Bind Variables
3527: b_class AR_PAYMENT_SCHEDULES.CLASS%TYPE;
3528: b_status AR_PAYMENT_SCHEDULES.STATUS%TYPE;
3529: b_interface_attr RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE9%TYPE;
3530: b_interface_context RA_CUSTOMER_TRX.INTERFACE_HEADER_CONTEXT%TYPE;
3531:
3532: BEGIN
3533:

Line 3530: b_interface_context RA_CUSTOMER_TRX.INTERFACE_HEADER_CONTEXT%TYPE;

3526: -- Bind Variables
3527: b_class AR_PAYMENT_SCHEDULES.CLASS%TYPE;
3528: b_status AR_PAYMENT_SCHEDULES.STATUS%TYPE;
3529: b_interface_attr RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE9%TYPE;
3530: b_interface_context RA_CUSTOMER_TRX.INTERFACE_HEADER_CONTEXT%TYPE;
3531:
3532: BEGIN
3533:
3534: b_interface_attr := 'CURE' ;

Line 3554: ra_customer_trx rct,

3550: v_cust_cnsld_sql :=
3551: 'SELECT count(distinct ocahb.id)
3552: FROM ar_payment_schedules arp,
3553: ar_aging_bucket_lines aabl,
3554: ra_customer_trx rct,
3555: okl_cnsld_ar_strms_b ocasb,
3556: OKL_CNSLD_AR_LINES_B ocalb,
3557: OKL_CNSLD_AR_HDRS_B ocahb
3558: WHERE (:l_date - arp.due_date) >= aabl.days_start

Line 3577: ra_customer_trx rct,

3573: v_party_cnsld_sql :=
3574: 'SELECT count(distinct ocahb.id)
3575: FROM ar_payment_schedules arp,
3576: ar_aging_bucket_lines aabl,
3577: ra_customer_trx rct,
3578: okl_cnsld_ar_strms_b ocasb,
3579: OKL_CNSLD_AR_LINES_B ocalb,
3580: OKL_CNSLD_AR_HDRS_B ocahb,
3581: HZ_CUST_ACCOUNTS hzca

Line 3609: ra_customer_trx rct,

3605: v_party_cnsld_sql :=
3606: 'SELECT count(distinct ocahb.id)
3607: FROM ar_payment_schedules arp,
3608: ar_aging_bucket_lines aabl,
3609: ra_customer_trx rct,
3610: okl_cnsld_ar_strms_b ocasb,
3611: OKL_CNSLD_AR_LINES_B ocalb,
3612: OKL_CNSLD_AR_HDRS_B ocahb,
3613: HZ_CUST_ACCOUNTS hzca

Line 3641: ra_customer_trx rct,

3637: v_party_billto_cnsld_sql :=
3638: 'SELECT count(distinct ocahb.id)
3639: FROM ar_payment_schedules arp,
3640: ar_aging_bucket_lines aabl,
3641: ra_customer_trx rct,
3642: okl_cnsld_ar_strms_b ocasb,
3643: OKL_CNSLD_AR_LINES_B ocalb,
3644: OKL_CNSLD_AR_HDRS_B ocahb,
3645: HZ_CUST_ACCOUNTS hzca