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 1632: ,okc_k_headers_b chr

1628: ,chr.inv_organization_id inv_organization_id
1629: FROM okl_asset_cndtn_lns_b acn,
1630: okl_asset_cndtns acd,
1631: okc_k_lines_v kle
1632: ,okc_k_headers_b chr
1633: WHERE acn.id = cp_acn_id
1634: AND acd.id = acn.acd_id
1635: AND kle.id = acd.kle_id
1636: AND kle.dnz_chr_id = chr.id;

Line 2913: FROM okc_k_headers_b

2909:
2910: -- Get contract end date
2911: CURSOR l_contract_csr (cp_contract_id NUMBER) IS
2912: SELECT end_date
2913: FROM okc_k_headers_b
2914: WHERE id = cp_contract_id;
2915:
2916: -- ansethur 03/02/2007 For R12B Billing Architecture project Start Changes
2917: -- Modified the cursor to exclude the reference of okl_xtl_sell_invs_b table.

Line 3509: okc_k_headers_b khr

3505: ,khr.inv_organization_id inv_organization_id,
3506: qte.art_id -- RRAVIKIR Legal Entity Changes
3507: FROM okl_trx_quotes_b qte,
3508: fnd_lookups flo,
3509: okc_k_headers_b khr
3510: WHERE qte.id = cp_quote_id
3511: AND flo.lookup_type = 'OKL_QUOTE_TYPE'
3512: AND flo.lookup_code = qte.qtp_code
3513: AND khr.id = qte.khr_id;

Line 3570: OKC_K_HEADERS_B chr

3566: qte.creation_date creation_date, --SECHAWLA 05-JAN-05 4926740 : added creation_date
3567: chr.inv_organization_id inv_organization_id,
3568: QTE.perdiem_amount -- rmunjulu LOANS_ENHACEMENTS
3569: FROM OKL_TRX_QUOTES_B qte,
3570: OKC_K_HEADERS_B chr
3571: WHERE qte.id = p_quote_id
3572: AND qte.khr_id = chr.id;-- rmunjulu 3985369
3573:
3574: -- rmunjulu EDAT -- Get the quote line meaning for BILL_ADJST

Line 3669: FROM OKC_K_HEADERS_B

3665:
3666: --bug#6766479 veramach start
3667: CURSOR check_cont_typ (cp_khr_id IN NUMBER) IS
3668: SELECT ORIG_SYSTEM_SOURCE_CODE
3669: FROM OKC_K_HEADERS_B
3670: WHERE id = cp_khr_id;
3671:
3672: l_cont_typ VARCHAR2(30);
3673:

Line 4659: OKC_K_HEADERS_B chr

4655: qte.date_effective_from date_eff_from,
4656: qte.date_accepted date_accepted,
4657: chr.inv_organization_id inv_organization_id
4658: FROM OKL_TRX_QUOTES_B qte,
4659: OKC_K_HEADERS_B chr
4660: WHERE qte.id = p_quote_id
4661: AND qte.khr_id = chr.id;
4662:
4663: l_partial_yn VARCHAR2(3);

Line 4709: okc_k_headers_b khr

4705: qte.currency_conversion_date currency_conversion_date,
4706: khr.inv_organization_id inv_organization_id
4707: FROM okl_trx_quotes_b qte,
4708: fnd_lookups flo,
4709: okc_k_headers_b khr
4710: WHERE qte.id = cp_quote_id
4711: AND flo.lookup_type = 'OKL_QUOTE_TYPE'
4712: AND flo.lookup_code = qte.qtp_code
4713: AND khr.id = qte.khr_id;