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 3564: b_interface_attr RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE9%TYPE;

3560:
3561: -- Bind Variables
3562: b_class AR_PAYMENT_SCHEDULES.CLASS%TYPE;
3563: b_status AR_PAYMENT_SCHEDULES.STATUS%TYPE;
3564: b_interface_attr RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE9%TYPE;
3565: b_interface_context RA_CUSTOMER_TRX.INTERFACE_HEADER_CONTEXT%TYPE;
3566:
3567: BEGIN
3568:

Line 3565: b_interface_context RA_CUSTOMER_TRX.INTERFACE_HEADER_CONTEXT%TYPE;

3561: -- Bind Variables
3562: b_class AR_PAYMENT_SCHEDULES.CLASS%TYPE;
3563: b_status AR_PAYMENT_SCHEDULES.STATUS%TYPE;
3564: b_interface_attr RA_CUSTOMER_TRX.INTERFACE_HEADER_ATTRIBUTE9%TYPE;
3565: b_interface_context RA_CUSTOMER_TRX.INTERFACE_HEADER_CONTEXT%TYPE;
3566:
3567: BEGIN
3568:
3569: b_interface_attr := 'CURE' ;

Line 3589: ra_customer_trx rct,

3585: v_cust_cnsld_sql :=
3586: 'SELECT count(distinct ocahb.id)
3587: FROM ar_payment_schedules arp,
3588: ar_aging_bucket_lines aabl,
3589: ra_customer_trx rct,
3590: okl_cnsld_ar_strms_b ocasb,
3591: OKL_CNSLD_AR_LINES_B ocalb,
3592: OKL_CNSLD_AR_HDRS_B ocahb
3593: WHERE (:l_date - arp.due_date) >= aabl.days_start

Line 3612: ra_customer_trx rct,

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

Line 3644: ra_customer_trx rct,

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

Line 3676: ra_customer_trx rct,

3672: v_party_billto_cnsld_sql :=
3673: 'SELECT count(distinct ocahb.id)
3674: FROM ar_payment_schedules arp,
3675: ar_aging_bucket_lines aabl,
3676: ra_customer_trx rct,
3677: okl_cnsld_ar_strms_b ocasb,
3678: OKL_CNSLD_AR_LINES_B ocalb,
3679: OKL_CNSLD_AR_HDRS_B ocahb,
3680: HZ_CUST_ACCOUNTS hzca