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 HZ_HIERARCHY_NODES

Line 187: , hz_hierarchy_nodes hn

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'
191: and hn.child_object_type = 'ORGANIZATION'

Line 243: , hz_hierarchy_nodes hn

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'
247: and hn.child_object_type = 'ORGANIZATION'

Line 2139: , hz_hierarchy_nodes hn

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
2143: AND hn.parent_id = p_party_id

Line 2163: , hz_hierarchy_nodes hn

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,
2167: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2187: , hz_hierarchy_nodes hn

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
2191: AND hn.parent_id = p_party_id

Line 2210: , hz_hierarchy_nodes hn

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,
2214: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2234: , hz_hierarchy_nodes hn

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
2238: AND hn.parent_object_type = 'ORGANIZATION'

Line 2572: , hz_hierarchy_nodes hn

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
2576: AND hn.parent_id = p_party_id

Line 2596: , hz_hierarchy_nodes hn

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,
2600: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2620: , hz_hierarchy_nodes hn

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
2624: AND hn.parent_id = p_party_id

Line 2644: , hz_hierarchy_nodes hn

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,
2648: b23, b24, b25, b26, b27, b28, b29, b30, b31,

Line 2668: , hz_hierarchy_nodes hn

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
2672: AND hn.parent_object_type = 'ORGANIZATION'

Line 10366: hz_hierarchy_nodes hn

10362: CURSOR C_g_use_party_hierarchy IS
10363: SELECT
10364: 'Y'
10365: FROM
10366: hz_hierarchy_nodes hn
10367: WHERE hn.parent_id = p_party_id
10368: AND hn.parent_object_type = 'ORGANIZATION'
10369: and hn.parent_table_name = 'HZ_PARTIES'
10370: and hn.child_object_type = 'ORGANIZATION'