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.OE_CREDIT_EXPOSURE_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 5224: -- ar_cash_receipts_all tables should all be locked in exclusive mode

5220: -- credit exposure information.
5221: -- The p_lock_tables flag specifies if
5222: -- the oe_order_lines_all, oe_order_headers_all,
5223: -- oe_cash_adjustments, ar_payment_schedules_all,
5224: -- ar_cash_receipts_all tables should all be locked in exclusive mode
5225: -- until all of the summary data is obtained.
5226: -- If the flag is not set to 'Y', none of the tables is locked.
5227: -- 08-22-03 Modified to only select lines with payment type cc flag = Y
5228: --=======================================================================--

Line 5387: LOCK TABLE ar_cash_receipts_all IN EXCLUSIVE MODE;

5383: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;
5384: LOCK TABLE oe_order_headers_all IN EXCLUSIVE MODE;
5385: LOCK TABLE oe_price_adjustments IN EXCLUSIVE MODE;
5386: LOCK TABLE ar_payment_schedules_all IN EXCLUSIVE MODE;
5387: LOCK TABLE ar_cash_receipts_all IN EXCLUSIVE MODE;
5388: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;
5389:
5390: IF G_debug_flag = 'Y'
5391: THEN

Line 9766: ar_cash_receipts_all cr

9762: , l_request_id
9763: , 1
9764:
9765: FROM
9766: ar_cash_receipts_all cr
9767: , ar_cash_receipt_history_all crh
9768: , hz_cust_accounts ca
9769: , hz_cust_site_uses_all su
9770: WHERE

Line 9940: ar_cash_receipts_all cr

9936: , l_request_id
9937: , 1
9938:
9939: FROM
9940: ar_cash_receipts_all cr
9941: , ar_cash_receipt_history_all crh
9942: , hz_cust_accounts ca
9943: , hz_cust_site_uses_all su
9944: WHERE