APPS.OKC_HZ_MERGE_PUB dependencies on HZ_CUST_ACCOUNTS

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

320: CURSOR c_account_count (b_chr_id NUMBER) IS
321: select count(*)
322: from (select okr1.object1_id1 from okc_rules_b okr1
323: where okr1.object1_id1 in (
324: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
325: ) and okr1.dnz_chr_id = b_chr_id
326: and okr1.rule_information_category IN ('BTO', 'STO')
327: union
328: select okr2.object2_id1 from okc_rules_b okr2

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

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

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

332: and okr2.rule_information_category IN ('BTO', 'STO')
333: union
334: select okr3.object3_id1 from okc_rules_b okr3
335: where okr3.object3_id1 in (
336: select TO_CHAR(cust_account_id) from hz_cust_accounts where party_id = l_source_party_id
337: ) and okr3.dnz_chr_id = b_chr_id
338: and okr3.rule_information_category IN ('BTO', 'STO')
339: union
340: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 364: (select to_char(cust_account_id) from hz_cust_accounts

360: from okc_k_lines_b where dnz_chr_id = b_chr_id )
361: and party_id =l_source_party_id
362: and SITE_USE_CODE = 'SHIP_TO')
363: union
364: (select to_char(cust_account_id) from hz_cust_accounts
365: where cust_account_id IN (select cust_acct_id
366: from okc_k_lines_b where dnz_chr_id = b_chr_id )
367: -- For Bug# 6861077
368: and party_id =l_source_party_id)

Line 370: (select to_char(cust_account_id) from hz_cust_accounts

366: from okc_k_lines_b where dnz_chr_id = b_chr_id )
367: -- For Bug# 6861077
368: and party_id =l_source_party_id)
369: union
370: (select to_char(cust_account_id) from hz_cust_accounts
371: where cust_account_id IN (select cust_acct_id
372: from okc_k_headers_b where id = b_chr_id )
373: -- Changes for Bug# 6861077 Ends
374: and party_id =l_source_party_id));

Line 2462: FROM hz_cust_accounts

2458: -- cursor to find party id given the account id
2459: --
2460: CURSOR c_party_id (b_account_id NUMBER) IS
2461: SELECT party_id
2462: FROM hz_cust_accounts
2463: WHERE cust_account_id = b_account_id
2464: ;
2465: --
2466: -- cursor to find if any contract is with the party of the