[Home] [Help]
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.
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;
5388: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;
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
5777: , hz_cust_site_uses_all su_l
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
5862: , hz_cust_site_uses_all su_l
7208: , 1
7209:
7210: FROM
7211: oe_price_adjustments p
7212: , oe_order_headers_all h
7213: , hz_cust_site_uses_all su
7214: , hz_cust_acct_sites_all s
7215: , hz_cust_accounts ca
7216: WHERE
7267: , 1
7268:
7269: FROM
7270: oe_price_adjustments p
7271: , oe_order_headers_all h
7272: , hz_cust_site_uses_all su
7273: , hz_cust_acct_sites_all s
7274: , hz_cust_accounts ca
7275: , ra_interface_lines_all rl
7363: , 1
7364:
7365: FROM
7366: oe_price_adjustments p
7367: , oe_order_headers_all h
7368: , hz_cust_site_uses_all su
7369: , hz_cust_acct_sites_all s
7370: , hz_cust_accounts ca
7371: WHERE
7424: , 1
7425:
7426: FROM
7427: oe_price_adjustments p
7428: , oe_order_headers_all h
7429: , hz_cust_site_uses_all su
7430: , hz_cust_acct_sites_all s
7431: , hz_cust_accounts ca
7432: , ra_interface_lines_all rl
7536: , l_request_id
7537:
7538: FROM
7539: oe_price_adjustments p
7540: , oe_order_headers_all h
7541: , hz_cust_site_uses_all su
7542: , hz_cust_acct_sites_all s
7543: , hz_cust_accounts ca
7544: WHERE
7594: , l_request_id
7595:
7596: FROM
7597: oe_price_adjustments p
7598: , oe_order_headers_all h
7599: , hz_cust_site_uses_all su
7600: , hz_cust_acct_sites_all s
7601: , hz_cust_accounts ca
7602: , ra_interface_lines_all rl
7687: , l_request_id
7688:
7689: FROM
7690: oe_price_adjustments p
7691: , oe_order_headers_all h
7692: , hz_cust_site_uses_all su
7693: , hz_cust_acct_sites_all s
7694: , hz_cust_accounts ca
7695: WHERE
7747: , l_request_id
7748:
7749: FROM
7750: oe_price_adjustments p
7751: , oe_order_headers_all h
7752: , hz_cust_site_uses_all su
7753: , hz_cust_acct_sites_all s
7754: , hz_cust_accounts ca
7755: , ra_interface_lines_all rl
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
8046: , hz_cust_accounts ca
9279: , 1
9280:
9281: FROM
9282: oe_price_adjustments p
9283: , oe_order_headers_all h
9284: , hz_cust_site_uses_all su
9285: , hz_cust_acct_sites_all s
9286: , hz_cust_accounts ca
9287: WHERE
9374: , 1
9375:
9376: FROM
9377: oe_price_adjustments p
9378: , oe_order_headers_all h
9379: , hz_cust_site_uses_all su
9380: , hz_cust_acct_sites_all s
9381: , hz_cust_accounts ca
9382: WHERE
9482: , l_request_id
9483:
9484: FROM
9485: oe_price_adjustments p
9486: , oe_order_headers_all h
9487: , hz_cust_site_uses_all su
9488: , hz_cust_acct_sites_all s
9489: , hz_cust_accounts ca
9490: WHERE
9576: , l_request_id
9577:
9578: FROM
9579: oe_price_adjustments p
9580: , oe_order_headers_all h
9581: , hz_cust_site_uses_all su
9582: , hz_cust_acct_sites_all s
9583: , hz_cust_accounts ca
9584: WHERE