DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_ORDER_LINES_ALL

Line 5222: -- the oe_order_lines_all, oe_order_headers_all,

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

Line 5383: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;

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

Line 5772: from oe_order_lines_all l

5768: ca.party_id order_party_id,
5769: s_l.cust_account_id line_cust_account_id,
5770: ca_l.party_id line_party_id,
5771: -999 interface_line_attribute6 --TaxER
5772: from oe_order_lines_all l
5773: , oe_order_headers_all h
5774: , hz_cust_site_uses_all su
5775: , hz_cust_acct_sites_all s
5776: , hz_cust_accounts ca

Line 5857: from oe_order_lines_all l

5853: ca.party_id order_party_id,
5854: s_l.cust_account_id line_cust_account_id,
5855: ca_l.party_id line_party_id,
5856: DECODE(OE_CREDIT_EXPOSURE_PVT.Is_Equal(rl.interface_line_attribute6,l.line_id),'Y',-999,to_number(rl.interface_line_attribute6)) interface_line_attribute6 --TaxER
5857: from oe_order_lines_all l
5858: , oe_order_headers_all h
5859: , hz_cust_site_uses_all su
5860: , hz_cust_acct_sites_all s
5861: , hz_cust_accounts ca

Line 7231: oe_order_lines_all l

7227: AND ca.cust_account_id = s.cust_account_id
7228: AND EXISTS
7229: ( SELECT NULL
7230: FROM oe_payment_types_all t,
7231: oe_order_lines_all l
7232: WHERE t.credit_check_flag = 'Y'
7233: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7234: AND l.header_id = h.header_id
7235: AND t.payment_type_code =

Line 7295: oe_order_lines_all l

7291: AND rl.interface_line_attribute6 = p.price_adjustment_id
7292: AND EXISTS
7293: ( SELECT NULL
7294: FROM oe_payment_types_all t,
7295: oe_order_lines_all l
7296: WHERE t.credit_check_flag = 'Y'
7297: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7298: AND l.header_id = h.header_id
7299: AND t.payment_type_code =

Line 7388: oe_order_lines_all l

7384: AND ca.cust_account_id = s.cust_account_id
7385: AND EXISTS
7386: ( SELECT NULL
7387: FROM oe_payment_types_all t,
7388: oe_order_lines_all l
7389: WHERE t.credit_check_flag = 'Y'
7390: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7391: AND l.header_id = h.header_id
7392: AND t.payment_type_code =

Line 7454: oe_order_lines_all l

7450: AND rl.interface_line_attribute6 = p.price_adjustment_id
7451: AND EXISTS
7452: ( SELECT NULL
7453: FROM oe_payment_types_all t,
7454: oe_order_lines_all l
7455: WHERE t.credit_check_flag = 'Y'
7456: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7457: AND l.header_id = h.header_id
7458: AND t.payment_type_code =

Line 7559: oe_order_lines_all l

7555: AND ca.cust_account_id = s.cust_account_id
7556: AND EXISTS
7557: ( SELECT NULL
7558: FROM oe_payment_types_all t,
7559: oe_order_lines_all l
7560: WHERE t.credit_check_flag = 'Y'
7561: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7562: AND l.header_id = h.header_id
7563: AND t.payment_type_code =

Line 7622: oe_order_lines_all l

7618: AND rl.interface_line_attribute6 = p.price_adjustment_id
7619: AND EXISTS
7620: ( SELECT NULL
7621: FROM oe_payment_types_all t,
7622: oe_order_lines_all l
7623: WHERE t.credit_check_flag = 'Y'
7624: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7625: AND l.header_id = h.header_id
7626: AND t.payment_type_code =

Line 7712: oe_order_lines_all l

7708: AND ca.cust_account_id = s.cust_account_id
7709: AND EXISTS
7710: ( SELECT NULL
7711: FROM oe_payment_types_all t,
7712: oe_order_lines_all l
7713: WHERE t.credit_check_flag = 'Y'
7714: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7715: AND l.header_id = h.header_id
7716: AND t.payment_type_code =

Line 7777: oe_order_lines_all l

7773: AND rl.interface_line_attribute6 = p.price_adjustment_id
7774: AND EXISTS
7775: ( SELECT NULL
7776: FROM oe_payment_types_all t,
7777: oe_order_lines_all l
7778: WHERE t.credit_check_flag = 'Y'
7779: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7780: AND l.header_id = h.header_id
7781: AND t.payment_type_code =

Line 8041: oe_order_lines_all l

8037: , SYSDATE
8038: , l_request_id
8039:
8040: FROM
8041: oe_order_lines_all l
8042: , oe_order_headers_all h
8043: , oe_payments p
8044: , hz_cust_site_uses_all su
8045: , hz_cust_acct_sites_all s

Line 9308: oe_order_lines_all l

9304: )
9305: AND EXISTS
9306: ( SELECT NULL
9307: FROM oe_payment_types_all t,
9308: oe_order_lines_all l
9309: WHERE t.credit_check_flag = 'Y'
9310: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9311: AND l.header_id = h.header_id
9312: AND t.payment_type_code =

Line 9405: oe_order_lines_all l

9401: )
9402: AND EXISTS
9403: ( SELECT NULL
9404: FROM oe_payment_types_all t,
9405: oe_order_lines_all l
9406: WHERE t.credit_check_flag = 'Y'
9407: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9408: AND l.header_id = h.header_id
9409: AND t.payment_type_code =

Line 9511: oe_order_lines_all l

9507: )
9508: AND EXISTS
9509: ( SELECT NULL
9510: FROM oe_payment_types_all t,
9511: oe_order_lines_all l
9512: WHERE t.credit_check_flag = 'Y'
9513: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9514: AND l.header_id = h.header_id
9515: AND t.payment_type_code =

Line 9607: oe_order_lines_all l

9603: )
9604: AND EXISTS
9605: ( SELECT NULL
9606: FROM oe_payment_types_all t,
9607: oe_order_lines_all l
9608: WHERE t.credit_check_flag = 'Y'
9609: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9610: AND l.header_id = h.header_id
9611: AND t.payment_type_code =