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

Line 80: ra_customer_trx_all inv

76: AND app.rowid <= p_end_rowid
77: AND ars.accounting_method = 'CASH'
78: AND NOT EXISTS (SELECT '1'
79: FROM psa_trx_types_all psa,
80: ra_customer_trx_all inv
81: WHERE inv.customer_trx_id = app.applied_customer_trx_id
82: AND inv.cust_trx_type_id = psa.psa_trx_type_id)
83: ORDER BY app.org_id;
84:

Line 342: ra_customer_trx_all trx,

338: AND rowid <= l_end_rowid
339: GROUP BY applied_customer_trx_id,
340: org_id ) app,
341: ar_system_parameters_all ars,
342: ra_customer_trx_all trx,
343: ra_customer_trx_lines_all ctl,
344: ra_cust_trx_line_gl_dist_all ctlgd
345: WHERE ars.accounting_method = 'CASH'
346: AND app.org_id = ars.org_id

Line 355: ra_customer_trx_all inv

351: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
352: AND ctlgd.account_set_flag = 'N'
353: AND NOT EXISTS (SELECT '1'
354: FROM psa_trx_types_all psa,
355: ra_customer_trx_all inv
356: WHERE inv.customer_trx_id = app.applied_customer_trx_id
357: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
358:
359:

Line 867: ra_customer_trx_all inv

863: AND app.customer_trx_id IS NOT NULL
864: AND app.cash_receipt_id IS NULL
865: AND NOT EXISTS (SELECT '1'
866: FROM psa_trx_types_all psa,
867: ra_customer_trx_all inv
868: WHERE inv.customer_trx_id = app.customer_trx_id
869: AND inv.cust_trx_type_id = psa.psa_trx_type_id)
870: ORDER BY app.org_id;
871:

Line 1130: ra_customer_trx_all trx,

1126: AND rowid <= l_end_rowid
1127: GROUP BY customer_trx_id,
1128: org_id ) app,
1129: ar_system_parameters_all ars,
1130: ra_customer_trx_all trx,
1131: ra_customer_trx_lines_all ctl,
1132: ra_cust_trx_line_gl_dist_all ctlgd
1133: WHERE ars.accounting_method = 'CASH'
1134: AND app.org_id = ars.org_id

Line 1143: ra_customer_trx_all inv

1139: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
1140: AND ctlgd.account_set_flag = 'N'
1141: AND NOT EXISTS (SELECT '1'
1142: FROM psa_trx_types_all psa,
1143: ra_customer_trx_all inv
1144: WHERE inv.customer_trx_id = app.customer_trx_id
1145: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
1146:
1147: