APPS.OE_CREDIT_CHECK_UTIL dependencies on HZ_HIERARCHY_NODES

Line 258: , hz_hierarchy_nodes hn

254: FROM hz_customer_profiles cp
255: , hz_cust_profile_amts cpa
256: , hz_credit_usages cu
257: , hz_credit_usage_rules cur
258: , hz_hierarchy_nodes hn
259: WHERE cp.party_id = hn.parent_id
260: AND cp.cust_account_id = -1
261: AND cp.site_use_id IS NULL
262: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 297: , hz_hierarchy_nodes hn

293: FROM hz_customer_profiles cp
294: , hz_cust_profile_amts cpa
295: , hz_credit_usages cu
296: , hz_credit_usage_rules cur
297: , hz_hierarchy_nodes hn
298: WHERE cp.party_id = hn.parent_id
299: AND cp.cust_account_id = -1
300: AND cp.site_use_id IS NULL
301: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 337: , hz_hierarchy_nodes hn

333: , cp.credit_checking credit_checking --bug 4967828
334: , cp.party_id
335: FROM hz_customer_profiles cp
336: , hz_cust_profile_amts cpa
337: , hz_hierarchy_nodes hn
338: WHERE cp.party_id = hn.parent_id
339: AND cp.cust_account_id = -1
340: AND cp.site_use_id IS NULL
341: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 3224: hz_hierarchy_nodes hn

3220: CURSOR C_g_use_party_hierarchy IS
3221: SELECT
3222: 'Y'
3223: FROM
3224: hz_hierarchy_nodes hn
3225: WHERE hn.parent_id = p_entity_id
3226: AND hn.parent_object_type = 'ORGANIZATION'
3227: and hn.parent_table_name = 'HZ_PARTIES'
3228: and hn.child_object_type = 'ORGANIZATION'

Line 3244: , hz_hierarchy_nodes hn

3240:
3241: CURSOR party_h_txn_cur IS
3242: SELECT distinct ( oes.currency_code) user_code
3243: FROM oe_credit_summaries oes
3244: , hz_hierarchy_nodes hn
3245: WHERE hn.parent_id = p_entity_id
3246: AND hn.parent_object_type = 'ORGANIZATION'
3247: and hn.parent_table_name = 'HZ_PARTIES'
3248: and hn.child_object_type = 'ORGANIZATION'