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.ARP_PROGRAM_GENERATE_BR dependencies on RA_CUSTOMER_TRX_LINES

Line 1905: - use NOT EXISTS in check against ra_customer_trx_lines

1901: /* Bug 3922691 :
1902: - replace trx.trx_date with ps.trx_date
1903: - replace (ps.due_date - pm.lead_days) <= SYSDATE
1904: with ps.due_date <= SYSDATE + pm.lead_days
1905: - use NOT EXISTS in check against ra_customer_trx_lines
1906: - remove join to hz_cust_acct_sites, this is done in construct_hz
1907: */
1908: /* Bug 4928711 - Removed the references to ap_bank_accounts */
1909:

Line 2046: ra_customer_trx_lines br_lines,

2042: and nvl(extn.instrument_id,-1) = decode(:p_customer_bank_account_id,-999, nvl(extn.instrument_id,-1),nvl(:p_customer_bank_account_id,-1))
2043: AND NOT EXISTS
2044: (SELECT br_ref_payment_schedule_id
2045: from
2046: ra_customer_trx_lines br_lines,
2047: ar_transaction_history th
2048: where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id
2049: and br_lines.customer_trx_id = th.customer_trx_id
2050: and th.current_record_flag = ''Y''

Line 2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2644: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2645:
2646:
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2648:
2649: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2650: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2651: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;

Line 3641: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;

3637: NULL, -- p_attribute15
3638: l_org_id, -- p_org_id
3639: l_customer_trx_line_id);
3640:
3641: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;
3642: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '
3643: || to_char(jnk1));
3644:
3645: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */

Line 4833: 'ra_customer_trx_lines br_lines, '||

4829: 'AND ps.customer_trx_id = NVL(:p_customer_trx_id,ps.customer_trx_id) '||
4830: 'AND ps.payment_schedule_id NOT IN '||
4831: '(SELECT br_ref_payment_schedule_id '||
4832: ' from '||
4833: 'ra_customer_trx_lines br_lines, '||
4834: 'ar_transaction_history th '||
4835: 'where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id '||
4836: 'and br_lines.customer_trx_id = th.customer_trx_id '||
4837: 'and th.current_record_flag = ''Y'' '||