APPS.OE_CREDIT_EXPOSURE_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 5223: -- oe_cash_adjustments, ar_payment_schedules_all,

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

Line 5386: LOCK TABLE ar_payment_schedules_all IN EXCLUSIVE MODE;

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

Line 9687: ar_payment_schedules_all sch ,

9683: , l_request_id
9684: , 1
9685:
9686: FROM
9687: ar_payment_schedules_all sch ,
9688: hz_cust_accounts ca
9689: , hz_cust_site_uses_all su
9690: WHERE
9691: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'

Line 9862: ar_payment_schedules_all sch ,

9858: , l_request_id
9859: , 1
9860:
9861: FROM
9862: ar_payment_schedules_all sch ,
9863: hz_cust_accounts ca
9864: , hz_cust_site_uses_all su
9865: WHERE
9866: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'

Line 10039: ar_payment_schedules_all sch ,

10035: , l_request_id
10036: , 1
10037:
10038: FROM
10039: ar_payment_schedules_all sch ,
10040: hz_cust_accounts ca
10041: WHERE
10042: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
10043: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')