APPS.OE_CREDIT_EXPOSURE_PVT dependencies on HZ_HIERARCHY_NODES

Line 173: , hz_hierarchy_nodes hn

169:
170: CURSOR chk_inv_past_due_party(p_curr_code IN VARCHAR2 ) IS
171: SELECT 'Y'
172: FROM OE_credit_summaries oes
173: , hz_hierarchy_nodes hn
174: WHERE hn.parent_id = p_party_id
175: AND hn.parent_object_type = 'ORGANIZATION'
176: and hn.parent_table_name = 'HZ_PARTIES'
177: and hn.child_object_type = 'ORGANIZATION'

Line 229: , hz_hierarchy_nodes hn

225:
226: CURSOR chk_inv_past_due_party_all IS
227: SELECT 'Y'
228: FROM OE_credit_summaries oes
229: , hz_hierarchy_nodes hn
230: WHERE hn.parent_id = p_party_id
231: AND hn.parent_object_type = 'ORGANIZATION'
232: and hn.parent_table_name = 'HZ_PARTIES'
233: and hn.child_object_type = 'ORGANIZATION'

Line 1847: , hz_hierarchy_nodes hn

1843: -------------------------------------------------------------
1844: CURSOR party_h_balance_csr_global IS
1845: SELECT SUM( oes.balance )
1846: FROM oe_credit_summaries oes
1847: , hz_hierarchy_nodes hn
1848: WHERE oes.balance_type IN
1849: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
1850: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22)
1851: AND hn.parent_id = p_party_id

Line 1871: , hz_hierarchy_nodes hn

1867: ---the same as above including Returns
1868: CURSOR party_h_bal_ret_csr_global IS
1869: SELECT SUM( oes.balance )
1870: FROM oe_credit_summaries oes
1871: , hz_hierarchy_nodes hn
1872: WHERE oes.balance_type IN
1873: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
1874: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
1875: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 1895: , hz_hierarchy_nodes hn

1891:
1892: CURSOR party_h_bal_stub_csr_gl IS
1893: SELECT SUM( oes.balance )
1894: FROM oe_credit_summaries oes
1895: , hz_hierarchy_nodes hn
1896: WHERE oes.balance_type IN
1897: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
1898: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22)
1899: AND hn.parent_id = p_party_id

Line 1918: , hz_hierarchy_nodes hn

1914: ---the same as above including Returns
1915: CURSOR party_h_bal_ret_stub_csr_gl IS
1916: SELECT SUM( oes.balance )
1917: FROM oe_credit_summaries oes
1918: , hz_hierarchy_nodes hn
1919: WHERE oes.balance_type IN
1920: (b1, b2, b3, b4, b5, b6, b7, b8, b9, b10,
1921: b11, b12, b13, b14, b15, b16, b17, b18, b21, b22,
1922: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 1942: , hz_hierarchy_nodes hn

1938:
1939: CURSOR party_br_h_stub_csr_gl IS
1940: SELECT SUM( oes.balance )
1941: FROM oe_credit_summaries oes
1942: , hz_hierarchy_nodes hn
1943: WHERE oes.balance_type IN
1944: (21,22)
1945: AND hn.parent_id = p_party_id
1946: AND hn.parent_object_type = 'ORGANIZATION'

Line 2280: , hz_hierarchy_nodes hn

2276: CURSOR party_h_all_curr_csr_global IS
2277: SELECT SUM( oes.balance )
2278: , oes.currency_code
2279: FROM oe_credit_summaries oes
2280: , hz_hierarchy_nodes hn
2281: WHERE oes.balance_type IN
2282: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2283: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22)
2284: AND hn.parent_id = p_party_id

Line 2304: , hz_hierarchy_nodes hn

2300: CURSOR party_h_all_curr_ret_csr_gl IS
2301: SELECT SUM( oes.balance )
2302: , oes.currency_code
2303: FROM oe_credit_summaries oes
2304: , hz_hierarchy_nodes hn
2305: WHERE oes.balance_type IN
2306: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2307: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,
2308: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2328: , hz_hierarchy_nodes hn

2324: CURSOR party_h_all_curr_stub_csr_gl IS
2325: SELECT SUM( oes.balance )
2326: , oes.currency_code
2327: FROM oe_credit_summaries oes
2328: , hz_hierarchy_nodes hn
2329: WHERE oes.balance_type IN
2330: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2331: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22)
2332: AND hn.parent_id = p_party_id

Line 2352: , hz_hierarchy_nodes hn

2348: CURSOR p_h_all_curr_stub_ret_csr_gl IS
2349: SELECT SUM( oes.balance )
2350: , oes.currency_code
2351: FROM oe_credit_summaries oes
2352: , hz_hierarchy_nodes hn
2353: WHERE oes.balance_type IN
2354: (b1, b2, b3, b4, b5, b6, b7, b8, b9,
2355: b10, b11, b12, b13, b14, b15, b16, b17, b18 , b21, b22,
2356: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2376: , hz_hierarchy_nodes hn

2372: CURSOR party_br_h_all_curr_stub_gl IS
2373: SELECT SUM( oes.balance )
2374: , oes.currency_code
2375: FROM oe_credit_summaries oes
2376: , hz_hierarchy_nodes hn
2377: WHERE oes.balance_type IN
2378: (21,22)
2379: AND hn.parent_id = p_party_id
2380: AND hn.parent_object_type = 'ORGANIZATION'

Line 8340: hz_hierarchy_nodes hn

8336: CURSOR C_g_use_party_hierarchy IS
8337: SELECT
8338: 'Y'
8339: FROM
8340: hz_hierarchy_nodes hn
8341: WHERE hn.parent_id = p_party_id
8342: AND hn.parent_object_type = 'ORGANIZATION'
8343: and hn.parent_table_name = 'HZ_PARTIES'
8344: and hn.child_object_type = 'ORGANIZATION'