eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_CREDIT_SUMMARIES

Line 155: FROM OE_credit_summaries

151: l_return VARCHAR2(1) ;
152:
153: CURSOR chk_inv_past_due_cust(p_curr_code IN VARCHAR2 ) IS
154: SELECT 'Y'
155: FROM OE_credit_summaries
156: WHERE cust_account_id = p_customer_id
157: AND currency_code = p_curr_code
158: AND bucket <= l_jdate
159: AND bucket_duration = 1

Line 167: FROM OE_credit_summaries

163: AND balance_type = 20 ;
164:
165: CURSOR chk_inv_past_due_cust_gl(p_curr_code IN VARCHAR2 ) IS
166: SELECT 'Y'
167: FROM OE_credit_summaries
168: WHERE cust_account_id = p_customer_id
169: AND currency_code = p_curr_code
170: AND bucket <= l_jdate
171: AND bucket_duration = 1

Line 177: FROM OE_credit_summaries

173:
174:
175: CURSOR chk_inv_past_due_site(p_curr_code IN VARCHAR2 ) IS
176: SELECT 'Y'
177: FROM OE_credit_summaries
178: WHERE site_use_id = p_site_use_id
179: AND currency_code = p_curr_code
180: AND bucket <= l_jdate
181: AND bucket_duration = 1

Line 186: FROM OE_credit_summaries oes

182: AND balance_type = 20 ;
183:
184: CURSOR chk_inv_past_due_party(p_curr_code IN VARCHAR2 ) IS
185: SELECT 'Y'
186: FROM OE_credit_summaries oes
187: , hz_hierarchy_nodes hn
188: WHERE hn.parent_id = p_party_id
189: AND hn.parent_object_type = 'ORGANIZATION'
190: and hn.parent_table_name = 'HZ_PARTIES'

Line 205: FROM OE_credit_summaries

201:
202: --Bug 4991241
203: CURSOR chk_inv_past_due_single_party(p_curr_code IN VARCHAR2 ) IS
204: SELECT 'Y'
205: FROM OE_credit_summaries
206: WHERE party_id = p_party_id
207: AND currency_code = p_curr_code
208: AND bucket <= l_jdate
209: AND bucket_duration = 1

Line 214: FROM OE_credit_summaries

210: AND balance_type = 20 ;
211:
212: CURSOR chk_inv_past_due_cust_all IS
213: SELECT 'Y'
214: FROM OE_credit_summaries
215: WHERE cust_account_id = p_customer_id
216: AND bucket <= l_jdate
217: AND bucket_duration = 1
218: AND ((org_id = p_org_id)

Line 225: FROM OE_credit_summaries

221: AND balance_type = 20 ;
222:
223: CURSOR chk_inv_past_due_cust_all_gl IS
224: SELECT 'Y'
225: FROM OE_credit_summaries
226: WHERE cust_account_id = p_customer_id
227: AND bucket <= l_jdate
228: AND bucket_duration = 1
229: AND balance_type = 20 ;

Line 234: FROM OE_credit_summaries

230:
231:
232: CURSOR chk_inv_past_due_site_all IS
233: SELECT 'Y'
234: FROM OE_credit_summaries
235: WHERE site_use_id = p_site_use_id
236: AND bucket <= l_jdate
237: AND bucket_duration = 1
238: AND balance_type = 20 ;

Line 242: FROM OE_credit_summaries oes

238: AND balance_type = 20 ;
239:
240: CURSOR chk_inv_past_due_party_all IS
241: SELECT 'Y'
242: FROM OE_credit_summaries oes
243: , hz_hierarchy_nodes hn
244: WHERE hn.parent_id = p_party_id
245: AND hn.parent_object_type = 'ORGANIZATION'
246: and hn.parent_table_name = 'HZ_PARTIES'

Line 260: FROM OE_credit_summaries

256:
257: --Bug 4991241
258: CURSOR chk_inv_past_party_single_all IS
259: SELECT 'Y'
260: FROM OE_credit_summaries
261: WHERE party_id = p_party_id
262: AND bucket <= l_jdate
263: AND bucket_duration = 1
264: AND balance_type = 20 ;

Line 1806: -- OE_CREDIT_SUMMARIES table for the balance types

1802: END convert_currency_amount;
1803:
1804: ----------------------------------------------------------
1805: ---- COMMENTS: Fucntion to select the overall exposure from the
1806: -- OE_CREDIT_SUMMARIES table for the balance types
1807: -- This function will be called from the main
1808: -- GET_EXPOSURE procedure both for AR and OM exposure
1809: -- as the exposure balance is governed by the
1810: -- balance types used

Line 1848: FROM oe_credit_summaries

1844: l_br_bucket_length NUMBER;
1845:
1846: CURSOR site_balance_csr IS
1847: SELECT SUM( balance )
1848: FROM oe_credit_summaries
1849: WHERE balance_type IN
1850: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1851: b10, b11, b12, b13, b14, b15, b16, b17, b18,b37,b38,b39,b40,b41,b42) --TaxER
1852: AND site_use_id = l_site_use_id

Line 1862: FROM oe_credit_summaries

1858: ---added for the Returns project
1859: ---the same as above including Returns
1860: CURSOR site_balance_ret_csr IS
1861: SELECT NVL(SUM( balance ),0)
1862: FROM oe_credit_summaries
1863: WHERE balance_type IN
1864: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1865: b10, b11, b12, b13, b14, b15, b16, b17, b18, b23, b24,
1866: b25, b26, b27, b28, b29, b30, b31, b32, b33, b34, b35, b36,b37,b38,b39,b40,b41,b42,b43,b44,b45,b46,b47,b48) --TaxER

Line 1875: FROM oe_credit_summaries

1871:
1872:
1873: CURSOR site_balance_stub_csr IS
1874: SELECT SUM( balance )
1875: FROM oe_credit_summaries
1876: WHERE balance_type IN
1877: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1878: b10, b11, b12, b13, b14, b15, b16, b17, b18,b37,b38,b39,b40,b41,b42) --TaxER
1879: AND site_use_id = l_site_use_id

Line 1889: FROM oe_credit_summaries

1885: ---added for the Returns project
1886: ---the same as above including Returns
1887: CURSOR site_balance_stub_ret_csr IS
1888: SELECT SUM( balance )
1889: FROM oe_credit_summaries
1890: WHERE balance_type IN
1891: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1892: b10, b11, b12, b13, b14, b15, b16, b17, b18, b23, b24,
1893: b25, b26, b27, b28, b29, b30, b31, b32, b33, b34, b35, b36,b37,b38,b39,b40,b41,b42,b43,b44,b45,b46,b47,b48) --TaxER

Line 1902: FROM oe_credit_summaries

1898:
1899:
1900: CURSOR site_br_stub_csr IS
1901: SELECT SUM( balance )
1902: FROM oe_credit_summaries
1903: WHERE balance_type IN
1904: (21,22)
1905: AND site_use_id = l_br_site_use_id
1906: AND currency_code = l_currency_code

Line 1914: FROM oe_credit_summaries

1910:
1911:
1912: CURSOR customer_balance_csr IS
1913: SELECT SUM( balance )
1914: FROM oe_credit_summaries
1915: WHERE balance_type IN
1916: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1917: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21,b22,b37,b38,b39,b40,b41,b42) --TaxER
1918: AND cust_account_id = p_customer_id

Line 1931: FROM oe_credit_summaries

1927: ---added for the Returns project
1928: ---the same as above including Returns
1929: CURSOR customer_balance_ret_csr IS
1930: SELECT SUM( balance )
1931: FROM oe_credit_summaries
1932: WHERE balance_type IN
1933: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1934: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21,b22, b23, b24,
1935: b25, b26, b27, b28, b29, b30, b31, b32, b33, b34, b35, b36,b37,b38,b39,b40,b41,b42,b43,b44,b45,b46,b47,b48) --TaxER

Line 1947: FROM oe_credit_summaries

1943:
1944:
1945: CURSOR customer_balance_stub_csr IS
1946: SELECT SUM( balance )
1947: FROM oe_credit_summaries
1948: WHERE balance_type IN
1949: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1950: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
1951: AND cust_account_id = p_customer_id

Line 1964: FROM oe_credit_summaries

1960: ---added for the Returns project
1961: ---the same as above including Returns
1962: CURSOR customer_balance_stub_ret_csr IS
1963: SELECT SUM( balance )
1964: FROM oe_credit_summaries
1965: WHERE balance_type IN
1966: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
1967: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21, b22, b23, b24,
1968: b25, b26, b27, b28, b29, b30, b31, b32, b33, b34, b35, b36,b37,b38,b39,b40,b41,b42,b43,b44,b45,b46,b47,b48) --TaxER

Line 1981: FROM oe_credit_summaries

1977:
1978:
1979: CURSOR customer_br_stub_csr IS
1980: SELECT SUM( balance )
1981: FROM oe_credit_summaries
1982: WHERE balance_type IN
1983: (21,22)
1984: AND cust_account_id = p_customer_id
1985: AND ((org_id = p_org_id)

Line 1996: FROM oe_credit_summaries

1992:
1993:
1994: CURSOR cust_balance_csr_global IS
1995: SELECT SUM( balance )
1996: FROM oe_credit_summaries
1997: WHERE balance_type IN
1998: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
1999: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2000: AND cust_account_id = p_customer_id

Line 2011: FROM oe_credit_summaries

2007: ---the same as above including Returns
2008:
2009: CURSOR cust_balance_ret_csr_global IS
2010: SELECT SUM( balance )
2011: FROM oe_credit_summaries
2012: WHERE balance_type IN
2013: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2014: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
2015: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2025: FROM oe_credit_summaries

2021: ;
2022:
2023: CURSOR cust_balance_stub_csr_global IS
2024: SELECT SUM( balance )
2025: FROM oe_credit_summaries
2026: WHERE balance_type IN
2027: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2028: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2029: AND cust_account_id = p_customer_id

Line 2039: FROM oe_credit_summaries

2035: ---added for the Returns project
2036: ---the same as above including Returns
2037: CURSOR cust_bal_stub_ret_csr_global IS
2038: SELECT SUM( balance )
2039: FROM oe_credit_summaries
2040: WHERE balance_type IN
2041: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2042: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
2043: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2053: FROM oe_credit_summaries

2049: ;
2050:
2051: CURSOR cust_br_stub_csr_global IS
2052: SELECT SUM( balance )
2053: FROM oe_credit_summaries
2054: WHERE balance_type IN
2055: (21,22)
2056: AND cust_account_id = p_customer_id
2057: AND currency_code = l_currency_code

Line 2067: FROM oe_credit_summaries

2063: --------------------------------------------------------------
2064:
2065: CURSOR party_balance_csr_global IS
2066: SELECT SUM( balance )
2067: FROM oe_credit_summaries
2068: WHERE balance_type IN
2069: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2070: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2071: AND party_id = p_party_id

Line 2082: FROM oe_credit_summaries

2078: ---the same as above including Returns
2079:
2080: CURSOR party_balance_ret_csr_global IS
2081: SELECT SUM( balance )
2082: FROM oe_credit_summaries
2083: WHERE balance_type IN
2084: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2085: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
2086: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2097: FROM oe_credit_summaries

2093:
2094:
2095: CURSOR party_balance_stub_csr_global IS
2096: SELECT SUM( balance )
2097: FROM oe_credit_summaries
2098: WHERE balance_type IN
2099: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2100: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2101: AND party_id = p_party_id

Line 2111: FROM oe_credit_summaries

2107: ---added for the Returns project
2108: ---the same as above including Returns
2109: CURSOR party_bal_stub_ret_csr_global IS
2110: SELECT SUM( balance )
2111: FROM oe_credit_summaries
2112: WHERE balance_type IN
2113: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2114: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
2115: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2125: FROM oe_credit_summaries

2121: ;
2122:
2123: CURSOR party_br_stub_csr_global IS
2124: SELECT SUM( balance )
2125: FROM oe_credit_summaries
2126: WHERE balance_type IN
2127: (21,22)
2128: AND party_id = p_party_id
2129: AND currency_code = l_currency_code

Line 2138: FROM oe_credit_summaries oes

2134:
2135: -------------------------------------------------------------
2136: CURSOR party_h_balance_csr_global IS
2137: SELECT SUM( oes.balance )
2138: FROM oe_credit_summaries oes
2139: , hz_hierarchy_nodes hn
2140: WHERE oes.balance_type IN
2141: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2142: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER

Line 2162: FROM oe_credit_summaries oes

2158: ---added for the Returns project
2159: ---the same as above including Returns
2160: CURSOR party_h_bal_ret_csr_global IS
2161: SELECT SUM( oes.balance )
2162: FROM oe_credit_summaries oes
2163: , hz_hierarchy_nodes hn
2164: WHERE oes.balance_type IN
2165: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2166: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,

Line 2186: FROM oe_credit_summaries oes

2182:
2183:
2184: CURSOR party_h_bal_stub_csr_gl IS
2185: SELECT SUM( oes.balance )
2186: FROM oe_credit_summaries oes
2187: , hz_hierarchy_nodes hn
2188: WHERE oes.balance_type IN
2189: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2190: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER

Line 2209: FROM oe_credit_summaries oes

2205: ---added for the Returns project
2206: ---the same as above including Returns
2207: CURSOR party_h_bal_ret_stub_csr_gl IS
2208: SELECT SUM( oes.balance )
2209: FROM oe_credit_summaries oes
2210: , hz_hierarchy_nodes hn
2211: WHERE oes.balance_type IN
2212: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
2213: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,

Line 2233: FROM oe_credit_summaries oes

2229:
2230:
2231: CURSOR party_br_h_stub_csr_gl IS
2232: SELECT SUM( oes.balance )
2233: FROM oe_credit_summaries oes
2234: , hz_hierarchy_nodes hn
2235: WHERE oes.balance_type IN
2236: (21,22)
2237: AND hn.parent_id = p_party_id

Line 2257: FROM oe_credit_summaries

2253:
2254: CURSOR site_balance_all_curr_csr IS
2255: SELECT SUM( balance )
2256: , currency_code
2257: FROM oe_credit_summaries
2258: WHERE balance_type IN
2259: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2260: b10, b11, b12, b13, b14, b15, b16, b17, b18,b37,b38,b39,b40,b41,b42) --TaxER
2261: AND site_use_id = l_site_use_id

Line 2273: FROM oe_credit_summaries

2269:
2270: CURSOR site_bal_all_curr_ret_csr IS
2271: SELECT SUM( balance )
2272: , currency_code
2273: FROM oe_credit_summaries
2274: WHERE balance_type IN
2275: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2276: b10, b11, b12, b13, b14, b15, b16, b17, b18,
2277: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2289: FROM oe_credit_summaries

2285:
2286: CURSOR site_balance_all_curr_stub_csr IS
2287: SELECT SUM( balance )
2288: , currency_code
2289: FROM oe_credit_summaries
2290: WHERE balance_type IN
2291: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2292: b10, b11, b12, b13, b14, b15, b16, b17, b18,b37,b38,b39,b40,b41,b42) --TaxER
2293: AND site_use_id = l_site_use_id

Line 2304: FROM oe_credit_summaries

2300: ---the same as above including Returns
2301: CURSOR site_bal_all_curr_stub_ret_csr IS
2302: SELECT SUM( balance )
2303: , currency_code
2304: FROM oe_credit_summaries
2305: WHERE balance_type IN
2306: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2307: b10, b11, b12, b13, b14, b15, b16, b17, b18,
2308: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2319: FROM oe_credit_summaries

2315:
2316: CURSOR site_br_all_curr_stub_csr IS
2317: SELECT SUM( balance )
2318: , currency_code
2319: FROM oe_credit_summaries
2320: WHERE balance_type IN
2321: (21,22)
2322: AND site_use_id = l_br_site_use_id
2323: AND bucket < l_br_bucket

Line 2332: FROM oe_credit_summaries

2328:
2329: CURSOR customer_balance_all_curr_csr IS
2330: SELECT SUM( balance )
2331: , currency_code
2332: FROM oe_credit_summaries
2333: WHERE balance_type IN
2334: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2335: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21, b22 ,b37,b38,b39,b40,b41,b42) --TaxER
2336: AND cust_account_id = p_customer_id

Line 2350: FROM oe_credit_summaries

2346: ---the same as above including Returns
2347: CURSOR customer_bal_all_curr_ret_csr IS
2348: SELECT SUM( balance )
2349: , currency_code
2350: FROM oe_credit_summaries
2351: WHERE balance_type IN
2352: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2353: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
2354: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2368: FROM oe_credit_summaries

2364:
2365: CURSOR customer_all_curr_stub_csr IS
2366: SELECT SUM( balance )
2367: , currency_code
2368: FROM oe_credit_summaries
2369: WHERE balance_type IN
2370: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2371: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2372: AND cust_account_id = p_customer_id

Line 2386: FROM oe_credit_summaries

2382: ---the same as above including Returns
2383: CURSOR customer_all_curr_stub_ret_csr IS
2384: SELECT SUM( balance )
2385: , currency_code
2386: FROM oe_credit_summaries
2387: WHERE balance_type IN
2388: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2389: b10, b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
2390: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2404: FROM oe_credit_summaries

2400:
2401: CURSOR customer_br_all_curr_stub_csr IS
2402: SELECT SUM( balance )
2403: , currency_code
2404: FROM oe_credit_summaries
2405: WHERE balance_type IN
2406: (21,22)
2407: AND cust_account_id = p_customer_id
2408: AND ((org_id = p_org_id)

Line 2420: FROM oe_credit_summaries

2416:
2417: CURSOR cust_all_curr_csr_global IS
2418: SELECT SUM( balance )
2419: , currency_code
2420: FROM oe_credit_summaries
2421: WHERE balance_type IN
2422: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2423: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2424: AND cust_account_id = p_customer_id

Line 2435: FROM oe_credit_summaries

2431: ---the same as above including Returns
2432: CURSOR cust_all_curr_ret_csr_global IS
2433: SELECT SUM( balance )
2434: , currency_code
2435: FROM oe_credit_summaries
2436: WHERE balance_type IN
2437: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2438: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,
2439: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2451: FROM oe_credit_summaries

2447:
2448: CURSOR cust_all_curr_stub_csr_global IS
2449: SELECT SUM( balance )
2450: , currency_code
2451: FROM oe_credit_summaries
2452: WHERE balance_type IN
2453: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2454: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2455: AND cust_account_id = p_customer_id

Line 2466: FROM oe_credit_summaries

2462: ---the same as above including Returns
2463: CURSOR cust_all_curr_stub_ret_csr_gl IS
2464: SELECT SUM( balance )
2465: , currency_code
2466: FROM oe_credit_summaries
2467: WHERE balance_type IN
2468: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2469: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,
2470: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2481: FROM oe_credit_summaries

2477:
2478: CURSOR cust_br_all_curr_stub_csr_gl IS
2479: SELECT SUM( balance )
2480: , currency_code
2481: FROM oe_credit_summaries
2482: WHERE balance_type IN
2483: (21,22)
2484: AND cust_account_id = p_customer_id
2485: AND bucket < l_br_bucket

Line 2496: FROM oe_credit_summaries

2492:
2493: CURSOR party_all_curr_csr_global IS
2494: SELECT SUM( balance )
2495: , currency_code
2496: FROM oe_credit_summaries
2497: WHERE balance_type IN
2498: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2499: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2500: AND party_id = p_party_id

Line 2511: FROM oe_credit_summaries

2507: ---the same as above including Returns
2508: CURSOR party_all_curr_ret_csr_gl IS
2509: SELECT SUM( balance )
2510: , currency_code
2511: FROM oe_credit_summaries
2512: WHERE balance_type IN
2513: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2514: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,
2515: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2526: FROM oe_credit_summaries

2522:
2523: CURSOR party_all_curr_stub_csr_global IS
2524: SELECT SUM( balance )
2525: , currency_code
2526: FROM oe_credit_summaries
2527: WHERE balance_type IN
2528: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2529: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,b37,b38,b39,b40,b41,b42) --TaxER
2530: AND party_id = p_party_id

Line 2541: FROM oe_credit_summaries

2537: ---the same as above including Returns
2538: CURSOR party_all_curr_stub_ret_csr_gl IS
2539: SELECT SUM( balance )
2540: , currency_code
2541: FROM oe_credit_summaries
2542: WHERE balance_type IN
2543: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2544: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,
2545: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2556: FROM oe_credit_summaries

2552:
2553: CURSOR party_br_all_curr_stub_csr_gl IS
2554: SELECT SUM( balance )
2555: , currency_code
2556: FROM oe_credit_summaries
2557: WHERE balance_type IN
2558: (21,22)
2559: AND party_id = p_party_id
2560: AND bucket < l_br_bucket

Line 2571: FROM oe_credit_summaries oes

2567:
2568: CURSOR party_h_all_curr_csr_global IS
2569: SELECT SUM( oes.balance )
2570: , oes.currency_code
2571: FROM oe_credit_summaries oes
2572: , hz_hierarchy_nodes hn
2573: WHERE oes.balance_type IN
2574: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2575: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,b37,b38,b39,b40,b41,b42) --TaxER

Line 2595: FROM oe_credit_summaries oes

2591: ---the same as above including Returns
2592: CURSOR party_h_all_curr_ret_csr_gl IS
2593: SELECT SUM( oes.balance )
2594: , oes.currency_code
2595: FROM oe_credit_summaries oes
2596: , hz_hierarchy_nodes hn
2597: WHERE oes.balance_type IN
2598: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2599: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,

Line 2619: FROM oe_credit_summaries oes

2615:
2616: CURSOR party_h_all_curr_stub_csr_gl IS
2617: SELECT SUM( oes.balance )
2618: , oes.currency_code
2619: FROM oe_credit_summaries oes
2620: , hz_hierarchy_nodes hn
2621: WHERE oes.balance_type IN
2622: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2623: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,b37,b38,b39,b40,b41,b42) --TaxER

Line 2643: FROM oe_credit_summaries oes

2639: ---the same as above including Returns
2640: CURSOR p_h_all_curr_stub_ret_csr_gl IS
2641: SELECT SUM( oes.balance )
2642: , oes.currency_code
2643: FROM oe_credit_summaries oes
2644: , hz_hierarchy_nodes hn
2645: WHERE oes.balance_type IN
2646: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2647: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,

Line 2667: FROM oe_credit_summaries oes

2663:
2664: CURSOR party_br_h_all_curr_stub_gl IS
2665: SELECT SUM( oes.balance )
2666: , oes.currency_code
2667: FROM oe_credit_summaries oes
2668: , hz_hierarchy_nodes hn
2669: WHERE oes.balance_type IN
2670: (21,22)
2671: AND hn.parent_id = p_party_id

Line 5219: -- which will repopulate oe_credit_summaries table with summarized

5215: -- p_lock_tables 'Y' or 'N' for all transaction tables
5216: ---
5217: -- COMMENT : This is the concurrent program body for
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,

Line 5420: l_sql_stmnt_hwm := 'ANALYZE TABLE '|| l_ont_schema||'.oe_credit_summaries ESTIMATE STATISTICS';

5416: END IF;
5417:
5418: --8567481 start
5419: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema);
5420: l_sql_stmnt_hwm := 'ANALYZE TABLE '|| l_ont_schema||'.oe_credit_summaries ESTIMATE STATISTICS';
5421: EXECUTE IMMEDIATE l_sql_stmnt_hwm;
5422: --8567481 end
5423:
5424: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'Y' THEN

Line 5426: DELETE FROM oe_credit_summaries

5422: --8567481 end
5423:
5424: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'Y' THEN
5425: /*14689044 start
5426: DELETE FROM oe_credit_summaries
5427: WHERE balance_type <> 18;
5428: 14689044 end*/
5429: --14689044 start
5430: DELETE FROM oe_credit_summaries

Line 5430: DELETE FROM oe_credit_summaries

5426: DELETE FROM oe_credit_summaries
5427: WHERE balance_type <> 18;
5428: 14689044 end*/
5429: --14689044 start
5430: DELETE FROM oe_credit_summaries
5431: WHERE balance_type IN(1,2,3,4,5,6,7,8,9,10,11,13,14,15,16,17,20,21,22,23,24,25,26,27,28,29,30,31,32
5432: ,33,34,35,36);
5433: --14689044 end
5434: ELSE

Line 5436: l_sql_stmnt := 'truncate table '||l_ont_schema ||'.oe_credit_summaries';

5432: ,33,34,35,36);
5433: --14689044 end
5434: ELSE
5435: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema); --This API is used to get schema name
5436: l_sql_stmnt := 'truncate table '||l_ont_schema ||'.oe_credit_summaries';
5437: EXECUTE IMMEDIATE l_sql_stmnt;
5438: END IF;
5439:
5440: /* comment out the following code for bug 4219133

Line 5442: DELETE FROM oe_credit_summaries

5438: END IF;
5439:
5440: /* comment out the following code for bug 4219133
5441: -- Do not delete external exposure data
5442: DELETE FROM oe_credit_summaries
5443: WHERE balance_type <> 18;
5444: */
5445:
5446:

Line 5928: -- Insert Tax Summaries into oe_credit_summaries

5924: -- check rule and other parameters.
5925:
5926:
5927: --------------------------------------------------------
5928: -- Insert Tax Summaries into oe_credit_summaries
5929: -- for uninvoiced orders and tax balance types at
5930: -- header bill-to-site level
5931:
5932: IF G_debug_flag = 'Y'

Line 5939: INSERT INTO oe_credit_summaries

5935: END IF;
5936: --14689044 IF l_cc_level_flag='Y' THEN
5937: IF l_header_uninvoiced_orders ='Y' THEN --14689044
5938: -- balance type 1
5939: INSERT INTO oe_credit_summaries
5940: ( balance
5941: , balance_type
5942: , site_use_id
5943: , cust_account_id

Line 6014: INSERT INTO OE_CREDIT_SUMMARIES

6010:
6011: --14689044 IF l_cc_level_flag='Y' THEN
6012: IF l_header_uninvoiced_orders_tax='Y' THEN --14689044
6013: -- balance type 3
6014: INSERT INTO OE_CREDIT_SUMMARIES
6015: ( balance
6016: , balance_type
6017: , site_use_id
6018: , cust_account_id

Line 6087: INSERT INTO oe_credit_summaries

6083: ----------------------------------------------
6084: --14689044 IF l_cc_level_flag='Y' THEN
6085: IF l_head_return_uninv_orders ='Y' THEN --14689044
6086: -- balance type 23
6087: INSERT INTO oe_credit_summaries
6088: ( balance
6089: , balance_type
6090: , site_use_id
6091: , cust_account_id

Line 6157: INSERT INTO OE_CREDIT_SUMMARIES

6153:
6154: --14689044 IF l_cc_level_flag='Y' THEN
6155: IF l_head_return_uninv_ord_tax ='Y' THEN --14689044
6156: -- balance type 25
6157: INSERT INTO OE_CREDIT_SUMMARIES
6158: ( balance
6159: , balance_type
6160: , site_use_id
6161: , cust_account_id

Line 6225: INSERT INTO OE_CREDIT_SUMMARIES

6221: -- h.invoice_to_org_id is replaced with l.invoice_to_org_id
6222:
6223: -- balance type 2
6224: IF l_line_uninvoiced_orders ='Y' THEN --14689044
6225: INSERT INTO OE_CREDIT_SUMMARIES
6226: ( balance
6227: , balance_type
6228: , site_use_id
6229: , cust_account_id

Line 6298: INSERT INTO OE_CREDIT_SUMMARIES

6294: END IF;
6295: END IF; --14689044
6296: -- balance type 4
6297: IF l_line_uninvoiced_orders_tax ='Y' THEN --14689044
6298: INSERT INTO OE_CREDIT_SUMMARIES
6299: ( balance
6300: , balance_type
6301: , site_use_id
6302: , cust_account_id

Line 6374: INSERT INTO OE_CREDIT_SUMMARIES

6370:
6371: -- balance type 24
6372: IF l_line_return_uninv_orders ='Y' THEN --14689044
6373:
6374: INSERT INTO OE_CREDIT_SUMMARIES
6375: ( balance
6376: , balance_type
6377: , site_use_id
6378: , cust_account_id

Line 6445: INSERT INTO OE_CREDIT_SUMMARIES

6441: END IF; --14689044
6442: -- balance type 26
6443: IF l_line_return_uninv_ord_tax ='Y' THEN --14689044
6444:
6445: INSERT INTO OE_CREDIT_SUMMARIES
6446: ( balance
6447: , balance_type
6448: , site_use_id
6449: , cust_account_id

Line 6515: INSERT INTO OE_CREDIT_SUMMARIES

6511: -- Line Freight
6512: --------------------------
6513:
6514: -- balance type 6
6515: INSERT INTO OE_CREDIT_SUMMARIES
6516: ( balance
6517: , balance_type
6518: , site_use_id
6519: , cust_account_id

Line 6593: INSERT INTO OE_CREDIT_SUMMARIES

6589: END IF;
6590:
6591: --TaxER Start
6592: IF l_tax = 'Y' THEN --14689044
6593: INSERT INTO OE_CREDIT_SUMMARIES
6594: ( balance
6595: , balance_type
6596: , site_use_id
6597: , cust_account_id

Line 6681: INSERT INTO OE_CREDIT_SUMMARIES

6677: --------------------------
6678:
6679: -- balance type 28
6680: IF l_line_return_uninv_freight ='Y' THEN --14689044
6681: INSERT INTO OE_CREDIT_SUMMARIES
6682: ( balance
6683: , balance_type
6684: , site_use_id
6685: , cust_account_id

Line 6756: INSERT INTO OE_CREDIT_SUMMARIES

6752:
6753:
6754: --TaxER Start
6755: IF l_tax = 'Y' THEN --14689044
6756: INSERT INTO OE_CREDIT_SUMMARIES
6757: ( balance
6758: , balance_type
6759: , site_use_id
6760: , cust_account_id

Line 6841: INSERT INTO OE_CREDIT_SUMMARIES

6837: --------------------------
6838: --14689044 IF l_cc_level_flag='Y' THEN
6839: -- balance type 5
6840:
6841: INSERT INTO OE_CREDIT_SUMMARIES
6842: ( balance
6843: , balance_type
6844: , site_use_id
6845: , cust_account_id

Line 6918: INSERT INTO OE_CREDIT_SUMMARIES

6914:
6915:
6916: --TaxER start
6917: IF l_tax = 'Y' THEN --14689044
6918: INSERT INTO OE_CREDIT_SUMMARIES
6919: ( balance
6920: , balance_type
6921: , site_use_id
6922: , cust_account_id

Line 7006: INSERT INTO OE_CREDIT_SUMMARIES

7002: --14689044 IF l_cc_level_flag='Y' THEN
7003: IF l_head_return_uninv_freight ='Y' THEN --14689044
7004: -- balance type 27
7005:
7006: INSERT INTO OE_CREDIT_SUMMARIES
7007: ( balance
7008: , balance_type
7009: , site_use_id
7010: , cust_account_id

Line 7079: INSERT INTO OE_CREDIT_SUMMARIES

7075: END IF;
7076:
7077: --TaxER Start
7078: IF l_tax = 'Y' THEN --14689044
7079: INSERT INTO OE_CREDIT_SUMMARIES
7080: ( balance
7081: , balance_type
7082: , site_use_id
7083: , cust_account_id

Line 7168: INSERT INTO OE_CREDIT_SUMMARIES

7164: -- this same balance type summary is added
7165:
7166: -- balance type 7
7167:
7168: INSERT INTO OE_CREDIT_SUMMARIES
7169: ( balance
7170: , balance_type
7171: , site_use_id
7172: , cust_account_id

Line 7323: INSERT INTO OE_CREDIT_SUMMARIES

7319: END IF;
7320:
7321: --TaxER Start
7322: IF l_tax = 'Y' THEN --14689044
7323: INSERT INTO OE_CREDIT_SUMMARIES
7324: ( balance
7325: , balance_type
7326: , site_use_id
7327: , cust_account_id

Line 7496: INSERT INTO OE_CREDIT_SUMMARIES

7492:
7493: -- balance type 29
7494: IF l_head_line_return_freight ='Y' THEN --14689044
7495:
7496: INSERT INTO OE_CREDIT_SUMMARIES
7497: ( balance
7498: , balance_type
7499: , site_use_id
7500: , cust_account_id

Line 7647: INSERT INTO OE_CREDIT_SUMMARIES

7643: END IF;
7644:
7645: --TaxER Start
7646: IF l_tax = 'Y' THEN --14689044
7647: INSERT INTO OE_CREDIT_SUMMARIES
7648: ( balance
7649: , balance_type
7650: , site_use_id
7651: , cust_account_id

Line 7819: INSERT INTO OE_CREDIT_SUMMARIES

7815: --14689044 IF l_cc_level_flag='Y' THEN
7816: -- balance type 10
7817: IF l_order_holds ='Y' THEN --14689044
7818:
7819: INSERT INTO OE_CREDIT_SUMMARIES
7820: ( balance
7821: , balance_type
7822: , site_use_id
7823: , cust_account_id

Line 7906: INSERT INTO OE_CREDIT_SUMMARIES

7902:
7903: --14689044 IF l_cc_level_flag='Y' THEN
7904: IF l_order_tax_holds ='Y' THEN --14689044
7905: -- balance type 13
7906: INSERT INTO OE_CREDIT_SUMMARIES
7907: ( balance
7908: , balance_type
7909: , site_use_id
7910: , cust_account_id

Line 7996: INSERT INTO OE_CREDIT_SUMMARIES

7992:
7993: --14689044 IF l_cc_level_flag='Y' THEN
7994: IF l_order_return_holds ='Y' THEN --14689044
7995: -- balance type 30
7996: INSERT INTO OE_CREDIT_SUMMARIES
7997: ( balance
7998: , balance_type
7999: , site_use_id
8000: , cust_account_id

Line 8105: INSERT INTO OE_CREDIT_SUMMARIES

8101: --14689044 IF l_cc_level_flag='Y' THEN
8102: IF l_order_return_tax_holds ='Y' THEN --14689044
8103: -- balance type 32
8104:
8105: INSERT INTO OE_CREDIT_SUMMARIES
8106: ( balance
8107: , balance_type
8108: , site_use_id
8109: , cust_account_id

Line 8186: INSERT INTO OE_CREDIT_SUMMARIES

8182:
8183: -- balance type 11
8184: IF l_line_holds ='Y' THEN --14689044
8185:
8186: INSERT INTO OE_CREDIT_SUMMARIES
8187: ( balance
8188: , balance_type
8189: , site_use_id
8190: , cust_account_id

Line 8270: INSERT INTO OE_CREDIT_SUMMARIES

8266: END IF; --14689044
8267: -- balance type 14
8268: IF l_line_tax_holds ='Y' THEN --14689044
8269:
8270: INSERT INTO OE_CREDIT_SUMMARIES
8271: ( balance
8272: , balance_type
8273: , site_use_id
8274: , cust_account_id

Line 8356: INSERT INTO OE_CREDIT_SUMMARIES

8352:
8353: -- balance type 31
8354: IF l_line_return_holds ='Y' THEN --14689044
8355:
8356: INSERT INTO OE_CREDIT_SUMMARIES
8357: ( balance
8358: , balance_type
8359: , site_use_id
8360: , cust_account_id

Line 8436: INSERT INTO OE_CREDIT_SUMMARIES

8432: -- balance type 33
8433:
8434: IF l_line_return_tax_holds ='Y' THEN --14689044
8435:
8436: INSERT INTO OE_CREDIT_SUMMARIES
8437: ( balance
8438: , balance_type
8439: , site_use_id
8440: , cust_account_id

Line 8516: INSERT INTO OE_CREDIT_SUMMARIES

8512: -- balance type 16
8513:
8514: IF l_line_freight_holds ='Y' THEN --14689044
8515:
8516: INSERT INTO OE_CREDIT_SUMMARIES
8517: ( balance
8518: , balance_type
8519: , site_use_id
8520: , cust_account_id

Line 8603: INSERT INTO OE_CREDIT_SUMMARIES

8599: END IF;
8600:
8601: --TaxER Start
8602: IF l_tax = 'Y' THEN --14689044
8603: INSERT INTO OE_CREDIT_SUMMARIES
8604: ( balance
8605: , balance_type
8606: , site_use_id
8607: , cust_account_id

Line 8702: INSERT INTO OE_CREDIT_SUMMARIES

8698: -- balance type 35
8699:
8700: IF l_line_return_freight_holds ='Y' THEN --14689044
8701:
8702: INSERT INTO OE_CREDIT_SUMMARIES
8703: ( balance
8704: , balance_type
8705: , site_use_id
8706: , cust_account_id

Line 8784: INSERT INTO OE_CREDIT_SUMMARIES

8780: END IF;
8781:
8782: --TaxER Start
8783: IF l_tax = 'Y' THEN --14689044
8784: INSERT INTO OE_CREDIT_SUMMARIES
8785: ( balance
8786: , balance_type
8787: , site_use_id
8788: , cust_account_id

Line 8878: INSERT INTO OE_CREDIT_SUMMARIES

8874: --14689044 IF l_cc_level_flag='Y' THEN
8875: IF l_order_freight_holds ='Y' THEN --14689044
8876: -- balance type 15
8877:
8878: INSERT INTO OE_CREDIT_SUMMARIES
8879: ( balance
8880: , balance_type
8881: , site_use_id
8882: , cust_account_id

Line 8965: INSERT INTO OE_CREDIT_SUMMARIES

8961: END IF;
8962:
8963: --TaxER Start
8964: IF l_tax = 'Y' THEN --14689044
8965: INSERT INTO OE_CREDIT_SUMMARIES
8966: ( balance
8967: , balance_type
8968: , site_use_id
8969: , cust_account_id

Line 9065: INSERT INTO OE_CREDIT_SUMMARIES

9061: --14689044 IF l_cc_level_flag='Y' THEN
9062: IF l_order_return_freight_holds ='Y' THEN --14689044
9063: -- balance type 34
9064:
9065: INSERT INTO OE_CREDIT_SUMMARIES
9066: ( balance
9067: , balance_type
9068: , site_use_id
9069: , cust_account_id

Line 9146: INSERT INTO OE_CREDIT_SUMMARIES

9142: END IF;
9143:
9144: --TaxER Start
9145: IF l_tax = 'Y' THEN --14689044
9146: INSERT INTO OE_CREDIT_SUMMARIES
9147: ( balance
9148: , balance_type
9149: , site_use_id
9150: , cust_account_id

Line 9239: INSERT INTO OE_CREDIT_SUMMARIES

9235: IF l_header_line_freight_holds ='Y' THEN --14689044
9236:
9237: -- balance type 17
9238:
9239: INSERT INTO OE_CREDIT_SUMMARIES
9240: ( balance
9241: , balance_type
9242: , site_use_id
9243: , cust_account_id

Line 9334: INSERT INTO OE_CREDIT_SUMMARIES

9330: END IF;
9331:
9332: --TaxER Start
9333: IF l_tax = 'Y' THEN --14689044
9334: INSERT INTO OE_CREDIT_SUMMARIES
9335: ( balance
9336: , balance_type
9337: , site_use_id
9338: , cust_account_id

Line 9442: INSERT INTO OE_CREDIT_SUMMARIES

9438: IF l_h_l_return_freight_holds ='Y' THEN --14689044
9439:
9440: -- balance type 36
9441:
9442: INSERT INTO OE_CREDIT_SUMMARIES
9443: ( balance
9444: , balance_type
9445: , site_use_id
9446: , cust_account_id

Line 9536: INSERT INTO OE_CREDIT_SUMMARIES

9532: END IF;
9533:
9534: --TaxER Start
9535: IF l_tax = 'Y' THEN --14689044
9536: INSERT INTO OE_CREDIT_SUMMARIES
9537: ( balance
9538: , balance_type
9539: , site_use_id
9540: , cust_account_id

Line 9645: INSERT INTO OE_CREDIT_SUMMARIES

9641: -- balance type 8
9642:
9643: IF l_invoices ='Y' THEN --14689044
9644:
9645: INSERT INTO OE_CREDIT_SUMMARIES
9646: ( balance
9647: , balance_type
9648: , site_use_id
9649: , cust_account_id

Line 9721: INSERT INTO OE_CREDIT_SUMMARIES

9717: -- balance type 9
9718:
9719: IF l_payments_at_risk ='Y' THEN --14689044
9720:
9721: INSERT INTO OE_CREDIT_SUMMARIES
9722: ( balance
9723: , balance_type
9724: , site_use_id
9725: , cust_account_id

Line 9818: INSERT INTO OE_CREDIT_SUMMARIES

9814: -- balance type 21
9815:
9816: IF l_br_invoices ='Y' THEN --14689044
9817:
9818: INSERT INTO OE_CREDIT_SUMMARIES
9819: ( balance
9820: , balance_type
9821: , site_use_id
9822: , cust_account_id

Line 9895: INSERT INTO OE_CREDIT_SUMMARIES

9891: -- balance type 22
9892:
9893: IF l_br_payments_at_risk ='Y' THEN --14689044
9894:
9895: INSERT INTO OE_CREDIT_SUMMARIES
9896: ( balance
9897: , balance_type
9898: , site_use_id
9899: , cust_account_id

Line 9997: INSERT INTO OE_CREDIT_SUMMARIES

9993: -- balance type 20
9994:
9995: IF l_past_due_invoices ='Y' THEN --14689044
9996:
9997: INSERT INTO OE_CREDIT_SUMMARIES
9998: ( balance
9999: , balance_type
10000: , site_use_id
10001: , cust_account_id

Line 10076: oe_credit_summaries

10072: l_bucket_length := POWER( 2, l_level );
10073:
10074: -- Commented for thr bug 7688615 to improve the performance.
10075: /*UPDATE
10076: oe_credit_summaries
10077: SET
10078: bucket_duration = l_bucket_length
10079: WHERE balance_type NOT IN (18,23,24,25,26,27,28,29,30,31,32,33,34,35,36); ---change for Returns
10080:

Line 10084: oe_credit_summaries

10080:
10081: */
10082: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'N' THEN
10083: UPDATE
10084: oe_credit_summaries
10085: SET
10086: bucket_duration = l_bucket_length
10087: WHERE balance_type =18;
10088: END IF;

Line 10122: oe_credit_summaries

10118: , currency_code
10119: , bucket
10120: , bucket_duration
10121: FROM
10122: oe_credit_summaries
10123: WHERE
10124: balance_type NOT IN (18,23,24,25,26,27,28,29,30,31,32,33,34,35,36); ---change for Returns
10125:
10126: WHILE l_level <= G_MAX_BUCKET_LEVEL LOOP

Line 10200: INSERT INTO /+ parallel / OE_CREDIT_SUMMARIES

10196: WHILE l_level <= G_MAX_BUCKET_LEVEL LOOP
10197:
10198: -- hints are introduced as part of the performance bug 7688615
10199:
10200: INSERT INTO /*+ parallel */ OE_CREDIT_SUMMARIES
10201: ( balance
10202: , balance_type
10203: , site_use_id
10204: , cust_account_id

Line 10242: oe_credit_summaries

10238: , SYSDATE
10239: , l_request_id
10240:
10241: FROM
10242: oe_credit_summaries
10243: WHERE
10244: bucket_duration = l_bucket_length / 2
10245: AND balance_type NOT IN (18,23,24,25,26,27,28,29,30,31,32,33,34,35,36) ---change for Returns
10246: GROUP BY

Line 10501: -- Goal: read-consistency of oe_credit_summaries during exposure

10497:
10498:
10499: -----------
10500: -- Locks needed for consistency
10501: -- Goal: read-consistency of oe_credit_summaries during exposure
10502: -- Means: SHARE lock or read-only transaction.
10503: -- SHARE: Need to verify that update overrides share.
10504: -- read-only: May slow down query due to reconstruction using
10505: -- rollback segment w.r.t SCN