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_CNTRCT_LN_TRMNT_PVT dependencies on OKC_K_HEADERS_V

Line 47: FROM okc_k_headers_v CHR,

43: )
44: IS
45: SELECT CHR.scs_code,
46: khr.deal_type
47: FROM okc_k_headers_v CHR,
48: okl_k_headers_v khr
49: WHERE CHR.ID = p_khr_id AND khr.ID = CHR.ID;
50:
51: l_lease_loan_type VARCHAR2 (30) := '$';

Line 358: FROM okc_k_headers_v khr

354: p_khr_id IN NUMBER
355: )
356: IS
357: SELECT khr.contract_number contract_number
358: FROM okc_k_headers_v khr
359: WHERE khr.ID = p_khr_id;
360:
361: l_module_name VARCHAR2 (500)
362: := g_module_name || 'set_database_values';

Line 1426: FROM okc_k_headers_v khr

1422: p_khr_id IN NUMBER
1423: )
1424: IS
1425: SELECT khr.sts_code sts_code
1426: FROM okc_k_headers_v khr
1427: WHERE khr.ID = p_khr_id;
1428:
1429: -- Get the status of the line
1430: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_LNS_FULL

Line 5150: lx_contract_currency okc_k_headers_v.currency_code%TYPE;

5146: --SECHAWLA Bug # 2726739 : new declarations
5147: l_func_curr_code gl_ledgers_public_v.currency_code%TYPE;
5148: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
5149: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL
5150: lx_contract_currency okc_k_headers_v.currency_code%TYPE;
5151: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;
5152: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%TYPE;
5153: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%TYPE;
5154: lx_converted_amount NUMBER;

Line 6165: FROM okc_k_headers_v khr

6161: p_khr_id IN NUMBER
6162: )
6163: IS
6164: SELECT khr.end_date end_date
6165: FROM okc_k_headers_v khr
6166: WHERE khr.ID = p_khr_id;
6167:
6168: l_return_status VARCHAR2 (1) := g_ret_sts_success;
6169: l_overall_status VARCHAR2 (1) := g_ret_sts_success;

Line 7985: okc_k_headers_v khr

7981: cle.NAME NAME,
7982: kle.residual_value residual_value
7983: FROM okl_k_lines_v kle,
7984: okc_k_lines_v cle,
7985: okc_k_headers_v khr
7986: WHERE cle.chr_id = p_khr_id
7987: AND cle.chr_id = khr.ID
7988: AND cle.sts_code = khr.sts_code
7989: AND kle.ID = cle.ID

Line 8013: FROM okc_k_headers_v khr

8009: p_khr_id IN NUMBER
8010: )
8011: IS
8012: SELECT khr.sts_code
8013: FROM okc_k_headers_v khr
8014: WHERE khr.ID = p_khr_id;
8015:
8016: -- RMUNJULU CONTRACT BLOCKING
8017: -- RMUNJULU CONTRACT BLOCKING (2)

Line 8397: FROM okc_k_headers_v khr

8393: )
8394: IS
8395: SELECT khr.end_date end_date,
8396: khr.sts_code sts_code
8397: FROM okc_k_headers_v khr
8398: WHERE khr.ID = p_chr_id;
8399:
8400: l_k_end_date DATE;
8401: l_return_status VARCHAR2 (1) := g_ret_sts_success;

Line 9117: FROM okc_k_headers_v khr

9113: )
9114: IS
9115: SELECT khr.end_date end_date,
9116: khr.sts_code sts_code
9117: FROM okc_k_headers_v khr
9118: WHERE khr.ID = p_chr_id;
9119:
9120: l_k_end_date DATE;
9121: l_return_status VARCHAR2 (1) := g_ret_sts_success;

Line 9363: okc_k_headers_v khr

9359: SELECT 1
9360: FROM okc_subclass_top_line stl,
9361: okc_line_styles_v lse,
9362: okc_k_lines_v cle,
9363: okc_k_headers_v khr
9364: WHERE cle.ID = p_top_line_id
9365: AND cle.dnz_chr_id = p_dnz_chr_id
9366: AND cle.cle_id IS NULL
9367: AND cle.chr_id = cle.dnz_chr_id

Line 12468: FROM okc_k_headers_v khr

12464: SELECT khr.object_version_number object_version_number,
12465: khr.sts_code sts_code,
12466: khr.authoring_org_id authoring_org_id
12467: --CDUBEY authoring_org_id added for MOAC
12468: FROM okc_k_headers_v khr
12469: WHERE khr.ID = p_khr_id;
12470:
12471: -- Cursor to get the ste code
12472: CURSOR get_old_ste_code_csr (

Line 12497: okc_k_headers_v khr

12493: )
12494: IS
12495: SELECT kle.ID ID
12496: FROM okc_k_lines_v kle,
12497: okc_k_headers_v khr
12498: WHERE kle.dnz_chr_id = p_khr_id
12499: AND kle.sts_code = khr.sts_code
12500: AND kle.chr_id = khr.ID;
12501:

Line 12935: okc_k_headers_v khr,

12931: )
12932: IS
12933: SELECT kle.ID ID
12934: FROM okc_k_lines_v kle,
12935: okc_k_headers_v khr,
12936: okc_line_styles_v lse
12937: WHERE kle.dnz_chr_id = p_khr_id
12938: AND kle.dnz_chr_id = khr.ID
12939: AND kle.sts_code = khr.sts_code