APPS.OKL_AM_INVOICES_PVT dependencies on OKC_K_HEADERS_B

Line 107: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE; -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes

103: l_par_id NUMBER;
104: l_rgd_id NUMBER;
105: l_party_name VARCHAR2(1000);
106:
107: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE; -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
108: l_party_role FND_LOOKUPS.meaning%TYPE; -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
109:
110: --l_bto_rulv_rec rulv_rec_type; -- Bill To Address Rule
111: l_mth_rulv_rec rulv_rec_type; -- Payment Method Rule

Line 141: -- PAGARG Bug 3559535 Make join of okc_k_headers_b par with okc_k_party_roles_v

137: -- This cursor called from REPURCHASE QUOTE
138: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
139: -- Get bill to site of vendor PROGRAM
140: -- RMUNJULU 3300594 Changed way to get bill_to_site_use_id, get from CPL not PAR
141: -- PAGARG Bug 3559535 Make join of okc_k_headers_b par with okc_k_party_roles_v
142: -- as outer join so that it returns te record of contract even if vendor program
143: -- is not there for that contract
144: CURSOR l_partner_rg_csr (cp_khr_id IN NUMBER) IS
145: SELECT khr.id khr_id,

Line 1530: ,okc_k_headers_b chr

1526: ,chr.inv_organization_id inv_organization_id
1527: FROM okl_asset_cndtn_lns_b acn,
1528: okl_asset_cndtns acd,
1529: okc_k_lines_v kle
1530: ,okc_k_headers_b chr
1531: WHERE acn.id = cp_acn_id
1532: AND acd.id = acn.acd_id
1533: AND kle.id = acd.kle_id
1534: AND kle.dnz_chr_id = chr.id;

Line 2807: FROM okc_k_headers_b

2803:
2804: -- Get contract end date
2805: CURSOR l_contract_csr (cp_contract_id NUMBER) IS
2806: SELECT end_date
2807: FROM okc_k_headers_b
2808: WHERE id = cp_contract_id;
2809:
2810: -- ansethur 03/02/2007 For R12B Billing Architecture project Start Changes
2811: -- Modified the cursor to exclude the reference of okl_xtl_sell_invs_b table.

Line 3403: okc_k_headers_b khr

3399: ,khr.inv_organization_id inv_organization_id,
3400: qte.art_id -- RRAVIKIR Legal Entity Changes
3401: FROM okl_trx_quotes_b qte,
3402: fnd_lookups flo,
3403: okc_k_headers_b khr
3404: WHERE qte.id = cp_quote_id
3405: AND flo.lookup_type = 'OKL_QUOTE_TYPE'
3406: AND flo.lookup_code = qte.qtp_code
3407: AND khr.id = qte.khr_id;

Line 3464: OKC_K_HEADERS_B chr

3460: qte.creation_date creation_date, --SECHAWLA 05-JAN-05 4926740 : added creation_date
3461: chr.inv_organization_id inv_organization_id,
3462: QTE.perdiem_amount -- rmunjulu LOANS_ENHACEMENTS
3463: FROM OKL_TRX_QUOTES_B qte,
3464: OKC_K_HEADERS_B chr
3465: WHERE qte.id = p_quote_id
3466: AND qte.khr_id = chr.id;-- rmunjulu 3985369
3467:
3468: -- rmunjulu EDAT -- Get the quote line meaning for BILL_ADJST

Line 3563: FROM OKC_K_HEADERS_B

3559:
3560: --bug#6766479 veramach start
3561: CURSOR check_cont_typ (cp_khr_id IN NUMBER) IS
3562: SELECT ORIG_SYSTEM_SOURCE_CODE
3563: FROM OKC_K_HEADERS_B
3564: WHERE id = cp_khr_id;
3565:
3566: l_cont_typ VARCHAR2(30);
3567:

Line 4546: OKC_K_HEADERS_B chr

4542: qte.date_effective_from date_eff_from,
4543: qte.date_accepted date_accepted,
4544: chr.inv_organization_id inv_organization_id
4545: FROM OKL_TRX_QUOTES_B qte,
4546: OKC_K_HEADERS_B chr
4547: WHERE qte.id = p_quote_id
4548: AND qte.khr_id = chr.id;
4549:
4550: l_partial_yn VARCHAR2(3);

Line 4596: okc_k_headers_b khr

4592: qte.currency_conversion_date currency_conversion_date,
4593: khr.inv_organization_id inv_organization_id
4594: FROM okl_trx_quotes_b qte,
4595: fnd_lookups flo,
4596: okc_k_headers_b khr
4597: WHERE qte.id = cp_quote_id
4598: AND flo.lookup_type = 'OKL_QUOTE_TYPE'
4599: AND flo.lookup_code = qte.qtp_code
4600: AND khr.id = qte.khr_id;