APPS.OKC_HZ_MERGE_PUB dependencies on OKX_CUST_SITE_USES_V

Line 333: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

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
334: where id1 IN (select bill_to_site_use_id
335: from okc_k_headers_b where id = b_chr_id)
336: and party_id = l_source_party_id
337: and SITE_USE_CODE = 'BILL_TO')

Line 339: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

335: from okc_k_headers_b where id = b_chr_id)
336: and party_id = l_source_party_id
337: and SITE_USE_CODE = 'BILL_TO')
338: union
339: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
340: where id1 IN (select ship_to_site_use_id
341: from okc_k_headers_b where id = b_chr_id )
342: and party_id =l_source_party_id
343: and SITE_USE_CODE = 'SHIP_TO')

Line 345: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

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

Line 351: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

347: from okc_k_lines_b where dnz_chr_id = b_chr_id)
348: and party_id = l_source_party_id
349: and SITE_USE_CODE = 'BILL_TO')
350: union
351: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
352: where id1 IN (select ship_to_site_use_id
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')