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 4913: -- ar_cash_receipts_all tables should all be locked in exclusive mode

4909: -- credit exposure information.
4910: -- The p_lock_tables flag specifies if
4911: -- the oe_order_lines_all, oe_order_headers_all,
4912: -- oe_cash_adjustments, ar_payment_schedules_all,
4913: -- ar_cash_receipts_all tables should all be locked in exclusive mode
4914: -- until all of the summary data is obtained.
4915: -- If the flag is not set to 'Y', none of the tables is locked.
4916: -- 08-22-03 Modified to only select lines with payment type cc flag = Y
4917: --=======================================================================--

Line 5027: LOCK TABLE ar_cash_receipts_all IN EXCLUSIVE MODE;

5023: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;
5024: LOCK TABLE oe_order_headers_all IN EXCLUSIVE MODE;
5025: LOCK TABLE oe_price_adjustments IN EXCLUSIVE MODE;
5026: LOCK TABLE ar_payment_schedules_all IN EXCLUSIVE MODE;
5027: LOCK TABLE ar_cash_receipts_all IN EXCLUSIVE MODE;
5028: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;
5029:
5030: IF G_debug_flag = 'Y'
5031: THEN

Line 7847: ar_cash_receipts_all cr

7843: , l_request_id
7844: , 1
7845:
7846: FROM
7847: ar_cash_receipts_all cr
7848: , ar_cash_receipt_history_all crh
7849: , hz_cust_accounts ca
7850: , hz_cust_site_uses_all su
7851: WHERE

Line 8016: ar_cash_receipts_all cr

8012: , l_request_id
8013: , 1
8014:
8015: FROM
8016: ar_cash_receipts_all cr
8017: , ar_cash_receipt_history_all crh
8018: , hz_cust_accounts ca
8019: , hz_cust_site_uses_all su
8020: WHERE