APPS.OKC_HZ_MERGE_PUB dependencies on OKX_CUST_SITE_USES_V

Line 340: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

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
341: where id1 IN (select bill_to_site_use_id
342: from okc_k_headers_b where id = b_chr_id)
343: and party_id = l_source_party_id
344: and SITE_USE_CODE = 'BILL_TO')

Line 346: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

342: from okc_k_headers_b where id = b_chr_id)
343: and party_id = l_source_party_id
344: and SITE_USE_CODE = 'BILL_TO')
345: union
346: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
347: where id1 IN (select ship_to_site_use_id
348: from okc_k_headers_b where id = b_chr_id )
349: and party_id =l_source_party_id
350: and SITE_USE_CODE = 'SHIP_TO')

Line 352: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

348: from okc_k_headers_b where id = b_chr_id )
349: and party_id =l_source_party_id
350: and SITE_USE_CODE = 'SHIP_TO')
351: union
352: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
353: where id1 IN (select bill_to_site_use_id
354: from okc_k_lines_b where dnz_chr_id = b_chr_id)
355: and party_id = l_source_party_id
356: and SITE_USE_CODE = 'BILL_TO')

Line 358: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

354: from okc_k_lines_b where dnz_chr_id = b_chr_id)
355: and party_id = l_source_party_id
356: and SITE_USE_CODE = 'BILL_TO')
357: union
358: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
359: where id1 IN (select ship_to_site_use_id
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')