APPS.OKC_HZ_MERGE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 317: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id

313: CURSOR c_account_count (b_chr_id NUMBER) IS
314: select count(*)
315: from (select okr1.object1_id1 from okc_rules_b okr1
316: where okr1.object1_id1 in (
317: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
318: ) and okr1.dnz_chr_id = b_chr_id
319: and okr1.rule_information_category IN ('BTO', 'STO')
320: union
321: select okr2.object2_id1 from okc_rules_b okr2

Line 323: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id

319: and okr1.rule_information_category IN ('BTO', 'STO')
320: union
321: select okr2.object2_id1 from okc_rules_b okr2
322: where okr2.object2_id1 in (
323: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
324: ) and okr2.dnz_chr_id = b_chr_id
325: and okr2.rule_information_category IN ('BTO', 'STO')
326: union
327: select okr3.object3_id1 from okc_rules_b okr3

Line 329: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id

325: and okr2.rule_information_category IN ('BTO', 'STO')
326: union
327: select okr3.object3_id1 from okc_rules_b okr3
328: where okr3.object3_id1 in (
329: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
330: ) and okr3.dnz_chr_id = b_chr_id
331: and okr3.rule_information_category IN ('BTO', 'STO')
332: union
333: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 357: (select to_char(cust_account_id) from hz_cust_accounts

353: from okc_k_lines_b where dnz_chr_id = b_chr_id )
354: and party_id =l_source_party_id
355: and SITE_USE_CODE = 'SHIP_TO')
356: union
357: (select to_char(cust_account_id) from hz_cust_accounts
358: where cust_account_id IN (select cust_acct_id
359: from okc_k_lines_b where dnz_chr_id = b_chr_id )
360: -- For Bug# 6861077
361: and party_id =l_source_party_id)

Line 363: (select to_char(cust_account_id) from hz_cust_accounts

359: from okc_k_lines_b where dnz_chr_id = b_chr_id )
360: -- For Bug# 6861077
361: and party_id =l_source_party_id)
362: union
363: (select to_char(cust_account_id) from hz_cust_accounts
364: where cust_account_id IN (select cust_acct_id
365: from okc_k_headers_b where id = b_chr_id )
366: -- Changes for Bug# 6861077 Ends
367: and party_id =l_source_party_id));

Line 2311: FROM hz_cust_accounts

2307: -- cursor to find party id given the account id
2308: --
2309: CURSOR c_party_id (b_account_id NUMBER) IS
2310: SELECT party_id
2311: FROM hz_cust_accounts
2312: WHERE cust_account_id = b_account_id
2313: ;
2314: --
2315: -- cursor to find if any contract is with the party of the