APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_ORDER_HEADERS_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 5024: LOCK TABLE oe_order_headers_all IN EXCLUSIVE MODE;

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;
5028: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;

Line 5163: , oe_order_headers_all h

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
5167: , hz_cust_site_uses_all su_l

Line 5221: , oe_order_headers_all h

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
5225: , hz_cust_site_uses_all su_l

Line 6208: , oe_order_headers_all h

6204: , 1
6205:
6206: FROM
6207: oe_price_adjustments p
6208: , oe_order_headers_all h
6209: , hz_cust_site_uses_all su
6210: , hz_cust_acct_sites_all s
6211: , hz_cust_accounts ca
6212: WHERE

Line 6267: , oe_order_headers_all h

6263: , 1
6264:
6265: FROM
6266: oe_price_adjustments p
6267: , oe_order_headers_all h
6268: , hz_cust_site_uses_all su
6269: , hz_cust_acct_sites_all s
6270: , hz_cust_accounts ca
6271: , ra_interface_lines_all rl

Line 6373: , oe_order_headers_all h

6369: , l_request_id
6370:
6371: FROM
6372: oe_price_adjustments p
6373: , oe_order_headers_all h
6374: , hz_cust_site_uses_all su
6375: , hz_cust_acct_sites_all s
6376: , hz_cust_accounts ca
6377: WHERE

Line 6431: , oe_order_headers_all h

6427: , l_request_id
6428:
6429: FROM
6430: oe_price_adjustments p
6431: , oe_order_headers_all h
6432: , hz_cust_site_uses_all su
6433: , hz_cust_acct_sites_all s
6434: , hz_cust_accounts ca
6435: , ra_interface_lines_all rl

Line 6712: , oe_order_headers_all h

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
6716: , hz_cust_accounts ca

Line 7569: , oe_order_headers_all h

7565: , 1
7566:
7567: FROM
7568: oe_price_adjustments p
7569: , oe_order_headers_all h
7570: , hz_cust_site_uses_all su
7571: , hz_cust_acct_sites_all s
7572: , hz_cust_accounts ca
7573: WHERE

Line 7670: , oe_order_headers_all h

7666: , l_request_id
7667:
7668: FROM
7669: oe_price_adjustments p
7670: , oe_order_headers_all h
7671: , hz_cust_site_uses_all su
7672: , hz_cust_acct_sites_all s
7673: , hz_cust_accounts ca
7674: WHERE