APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_ORDER_LINES_ALL

Line 4911: -- the oe_order_lines_all, oe_order_headers_all,

4907: -- Initialize Credit Summaries Table
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.

Line 5023: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;

5019: THEN
5020: oe_debug_pub.add( 'starting to lock tables', 2 );
5021: END IF;
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;

Line 5162: from oe_order_lines_all l

5158: s.cust_account_id order_cust_account_id,
5159: ca.party_id order_party_id,
5160: s_l.cust_account_id line_cust_account_id,
5161: ca_l.party_id line_party_id
5162: from oe_order_lines_all l
5163: , oe_order_headers_all h
5164: , hz_cust_site_uses_all su
5165: , hz_cust_acct_sites_all s
5166: , hz_cust_accounts ca

Line 5220: from oe_order_lines_all l

5216: s.cust_account_id order_cust_account_id,
5217: ca.party_id order_party_id,
5218: s_l.cust_account_id line_cust_account_id,
5219: ca_l.party_id line_party_id
5220: from oe_order_lines_all l
5221: , oe_order_headers_all h
5222: , hz_cust_site_uses_all su
5223: , hz_cust_acct_sites_all s
5224: , hz_cust_accounts ca

Line 6227: oe_order_lines_all l

6223: AND ca.cust_account_id = s.cust_account_id
6224: AND EXISTS
6225: ( SELECT NULL
6226: FROM oe_payment_types_all t,
6227: oe_order_lines_all l
6228: WHERE t.credit_check_flag = 'Y'
6229: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6230: AND l.header_id = h.header_id
6231: AND t.payment_type_code =

Line 6291: oe_order_lines_all l

6287: AND rl.interface_line_attribute6 = p.price_adjustment_id
6288: AND EXISTS
6289: ( SELECT NULL
6290: FROM oe_payment_types_all t,
6291: oe_order_lines_all l
6292: WHERE t.credit_check_flag = 'Y'
6293: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6294: AND l.header_id = h.header_id
6295: AND t.payment_type_code =

Line 6392: oe_order_lines_all l

6388: AND ca.cust_account_id = s.cust_account_id
6389: AND EXISTS
6390: ( SELECT NULL
6391: FROM oe_payment_types_all t,
6392: oe_order_lines_all l
6393: WHERE t.credit_check_flag = 'Y'
6394: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6395: AND l.header_id = h.header_id
6396: AND t.payment_type_code =

Line 6455: oe_order_lines_all l

6451: AND rl.interface_line_attribute6 = p.price_adjustment_id
6452: AND EXISTS
6453: ( SELECT NULL
6454: FROM oe_payment_types_all t,
6455: oe_order_lines_all l
6456: WHERE t.credit_check_flag = 'Y'
6457: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6458: AND l.header_id = h.header_id
6459: AND t.payment_type_code =

Line 6711: oe_order_lines_all l

6707: , SYSDATE
6708: , l_request_id
6709:
6710: FROM
6711: oe_order_lines_all l
6712: , oe_order_headers_all h
6713: , oe_payments p
6714: , hz_cust_site_uses_all su
6715: , hz_cust_acct_sites_all s

Line 7594: oe_order_lines_all l

7590: )
7591: AND EXISTS
7592: ( SELECT NULL
7593: FROM oe_payment_types_all t,
7594: oe_order_lines_all l
7595: WHERE t.credit_check_flag = 'Y'
7596: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7597: AND l.header_id = h.header_id
7598: AND t.payment_type_code =

Line 7695: oe_order_lines_all l

7691: )
7692: AND EXISTS
7693: ( SELECT NULL
7694: FROM oe_payment_types_all t,
7695: oe_order_lines_all l
7696: WHERE t.credit_check_flag = 'Y'
7697: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7698: AND l.header_id = h.header_id
7699: AND t.payment_type_code =