APPS.OE_CREDIT_EXPOSURE_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 4912: -- oe_cash_adjustments, ar_payment_schedules_all,

4908: -- which will repopulate oe_credit_summaries table with summarized
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

Line 5026: LOCK TABLE ar_payment_schedules_all IN EXCLUSIVE MODE;

5022:
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'

Line 7771: ar_payment_schedules_all sch ,

7767: , l_request_id
7768: , 1
7769:
7770: FROM
7771: ar_payment_schedules_all sch ,
7772: hz_cust_accounts ca
7773: , hz_cust_site_uses_all su
7774: WHERE
7775: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'

Line 7940: ar_payment_schedules_all sch ,

7936: , l_request_id
7937: , 1
7938:
7939: FROM
7940: ar_payment_schedules_all sch ,
7941: hz_cust_accounts ca
7942: , hz_cust_site_uses_all su
7943: WHERE
7944: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'

Line 8111: ar_payment_schedules_all sch ,

8107: , l_request_id
8108: , 1
8109:
8110: FROM
8111: ar_payment_schedules_all sch ,
8112: hz_cust_accounts ca
8113: WHERE
8114: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
8115: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')