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.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_CUSTOMER_TRX_ALL

Line 1195: FROM ra_customer_trx_all rx,

1191: SELECT rx.TRX_NUMBER,
1192: rl.customer_trx_line_id
1193: INTO x_out_rec.cm_trx_number,
1194: x_out_rec.cm_customer_trx_line_id
1195: FROM ra_customer_trx_all rx,
1196: ra_customer_trx_lines_all rl
1197: WHERE rx.customer_trx_id = x_cm_customer_trx_id
1198: AND rl.customer_trx_id = rx.customer_trx_id;
1199: END IF;

Line 4330: ra_customer_trx_all rct,

4326: Max(arp.receivable_application_id)
4327: INTO x_cash_receipt_id,
4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id
4334: AND arp.org_id = p_org_id

Line 5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl

5867: SELECT rc.CUSTOMER_TRX_ID,
5868: rc.TRX_NUMBER
5869: INTO l_customer_trx_id,
5870: l_trx_number
5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl
5872: WHERE rc.CUSTOMER_TRX_ID = rcl.CUSTOMER_TRX_ID
5873: AND rcl.INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5874: AND rcl.INTERFACE_LINE_ATTRIBUTE7 = to_char(l_emd_transactions_info.emd_trx_group_id)
5875: AND rcl.INTERFACE_LINE_ATTRIBUTE8 = to_char(l_emd_transactions_info.emd_transaction_id)