eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_K_HEADERS_B

Line 948: FROM OKC_K_HEADERS_b --sechawla 18-dec-07 6690811 : changed OKC_K_HEADERS_V to OKC_K_HEADERS_b

944: -- Cursor to get the end date of contract
945: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
946: CURSOR get_k_end_date_csr ( p_khr_id IN NUMBER) IS
947: SELECT end_date, sts_code --sechawla 18-dec-07 6690811 : added sts_code
948: FROM OKC_K_HEADERS_b --sechawla 18-dec-07 6690811 : changed OKC_K_HEADERS_V to OKC_K_HEADERS_b
949: WHERE id = p_khr_id;
950:
951: --sechawla 18-dec-07 6690811
952: l_k_sts_code VARCHAR2(30);

Line 2323: FROM okc_k_headers_b

2319:
2320: -- 20-JAN-06 SECHAWLA 4970009 : added
2321: CURSOR l_okcheaders_b(cp_khr_id IN NUMBER) IS
2322: SELECT end_date
2323: FROM okc_k_headers_b
2324: WHERE id = cp_khr_id;
2325:
2326: l_end_date DATE;
2327: -- asawanka added for debug feature start

Line 2737: FROM OKC_K_HEADERS_B

2733: SELECT id,
2734: object_version_number,
2735: sts_code,
2736: authoring_org_id --CDUBEY authoring_org_id added for MOAC
2737: FROM OKC_K_HEADERS_B
2738: WHERE id = p_term_rec.p_contract_id;
2739:
2740: -- Cursor to get all lines for the contract
2741: -- Cannot use the klev_tbl as these are financial lines only

Line 2747: OKC_K_HEADERS_B KHR

2743: CURSOR k_lines_csr (p_khr_id IN NUMBER) IS
2744: SELECT KLE.id kle_id,
2745: KLE.line_number line_number
2746: FROM OKC_K_LINES_B KLE,
2747: OKC_K_HEADERS_B KHR
2748: WHERE KLE.dnz_chr_id = p_khr_id
2749: AND KLE.sts_code = KHR.sts_code
2750: AND KLE.dnz_chr_id = KHR.id;
2751:

Line 4097: FROM OKC_K_HEADERS_B

4093:
4094: -- Cursor to get the end date of contract -- Can get from main API
4095: CURSOR k_end_date_csr ( p_chr_id IN NUMBER) IS
4096: SELECT end_date
4097: FROM OKC_K_HEADERS_B
4098: WHERE id = p_chr_id;
4099:
4100: l_k_end_date DATE;
4101: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 6165: okc_k_headers_b chr, -- rmunjulu Bug 4162862

6161: ,chr.org_id --akrangan added for sla ae uptake cr
6162: ,khr.multi_gaap_yn --MGAAP 7263041
6163: ,pdt.reporting_pdt_id --MGAAP 7263041
6164: FROM okl_k_headers_v khr,
6165: okc_k_headers_b chr, -- rmunjulu Bug 4162862
6166: okl_products pdt
6167: WHERE khr.id = p_khr_id AND khr.id = chr.id -- rmunjulu Bug 4162862
6168: AND khr.pdt_id = pdt.ID; -- MGAAP 7263041
6169:

Line 6317: FROM okc_k_headers_b chr

6313:
6314: -- rmunjulu 4141991 Cursor to get the product of the contract
6315: CURSOR get_k_sts_csr(p_khr_id IN NUMBER) IS
6316: SELECT chr.sts_code
6317: FROM okc_k_headers_b chr
6318: WHERE chr.id = p_khr_id;
6319:
6320: -- rmunjulu 4141991
6321: l_k_sts VARCHAR2(300);

Line 6339: l_scs_code okc_k_headers_b.scs_code%TYPE;

6335: -- rmunjulu 4424713
6336: l_deal_type VARCHAR2(150);
6337:
6338: -- rmunjulu 4622198
6339: l_scs_code okc_k_headers_b.scs_code%TYPE;
6340: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
6341: l_inv_acct_code okc_rules_b.rule_information1%TYPE;
6342:
6343: --rmunjulu 4769094

Line 7813: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

7809: END process_accounting_entries;
7810:
7811: PROCEDURE Create_Repo_asset_2(
7812: p_init_msg_list IN VARCHAR2,
7813: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
7814: p_kle_id IN OKL_K_LINES.ID%TYPE,
7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,

Line 8299: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

8295: --RKUTTIYA Added for bug 6674370
8296: --Call to SLA Populate Sources
8297: PROCEDURE Populate_Sources(p_api_version IN NUMBER,
8298: p_init_msg_list IN VARCHAR2,
8299: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8300: p_kle_id IN OKL_K_LINES.ID%TYPE,
8301: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8302: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8303: p_tal_id IN NUMBER,

Line 8409: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,

8405:
8406:
8407: PROCEDURE Create_Repo_asset(
8408: p_init_msg_list IN VARCHAR2,
8409: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8410: p_kle_id IN OKL_K_LINES.ID%TYPE,
8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,

Line 9081: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;

9077: l_proceeds_of_sale NUMBER;
9078:
9079: --SECHAWLA Bug # 2726739 : new declarations
9080: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
9081: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
9082: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
9083: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
9084: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
9085: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;

Line 9103: OKC_K_HEADERS_B CHR

9099: KHR.DEAL_TYPE,
9100: CHR.AUTHORING_ORG_ID
9101: FROM OKL_TRX_QUOTES_V OTQV,
9102: OKL_K_HEADERS KHR,
9103: OKC_K_HEADERS_B CHR
9104: WHERE OTQV.ID = p_quote_id
9105: AND OTQV.KHR_ID = KHR.ID
9106: AND KHR.ID = CHR.ID;
9107:

Line 9110: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

9106: AND KHR.ID = CHR.ID;
9107:
9108: l_repo_yn OKL_TRX_QUOTES_V.REPO_QUOTE_INDICATOR_YN%TYPE := 'N';
9109: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
9110: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
9111:
9112: CURSOR c_get_loan_repo_params(p_org_id NUMBER) IS
9113: --SELECT CORPORATE_BOOK,
9114: SELECT ASST_ADD_BOOK_TYPE_CODE CORPORATE_BOOK,