DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 3128: FROM okc_k_headers_all_b okch, okc_k_lines_v okcl

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;

Line 3148: FROM okc_k_headers_all_b

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: