3124: WHERE
3125: a.cust_acct_site_id = b.cust_acct_site_id
3126: AND b.site_use_code = 'BILL_TO'
3127: AND b.site_use_id = (SELECT DECODE(okcl.bill_to_site_use_id, null, okch.bill_to_site_use_id, okcl.bill_to_site_use_id)
3128: FROM okc_k_headers_all_b okch, okc_k_lines_v okcl
3129: WHERE okcl.dnz_chr_id = okch.id
3130: AND okcl.id = p_fin_asset_id)
3131: AND a.party_site_id = c.party_site_id
3132: AND a.cust_account_id = p_cust_acct_id;
3144: WHERE
3145: a.cust_acct_site_id = b.cust_acct_site_id
3146: AND b.site_use_code = 'BILL_TO'
3147: AND b.site_use_id = (SELECT bill_to_site_use_id
3148: FROM okc_k_headers_all_b
3149: WHERE id = p_khr_id)
3150: AND a.party_site_id = c.party_site_id
3151: AND a.cust_account_id = p_cust_acct_id;
3152: