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 OKL_K_HEADERS_V

Line 48: okl_k_headers_v khr

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) := '$';
52: k_deal_type_rec k_deal_type_csr%ROWTYPE;

Line 3800: FROM okl_k_headers_v khr,

3796: SELECT khr.pdt_id pdt_id,
3797: CHR.scs_code -- rmunjulu 4622198
3798: ,
3799: CHR.org_id --akrangan added for sla ae uptake
3800: FROM okl_k_headers_v khr,
3801: okc_k_headers_b CHR -- rmunjulu 4622198
3802: WHERE khr.ID = p_khr_id AND khr.ID = CHR.ID; -- rmunjulu 4622198
3803:
3804: -- Get the product type

Line 5151: lx_currency_conversion_type okl_k_headers_v.currency_conversion_type%TYPE;

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;
5155: -- rmunjulu EDAT

Line 5152: lx_currency_conversion_rate okl_k_headers_v.currency_conversion_rate%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;
5155: -- rmunjulu EDAT
5156: l_quote_accpt_date DATE;

Line 5153: lx_currency_conversion_date okl_k_headers_v.currency_conversion_date%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;
5155: -- rmunjulu EDAT
5156: l_quote_accpt_date DATE;
5157: l_quote_eff_date DATE;

Line 7140: FROM okl_k_headers_v khr

7136: p_khr_id IN NUMBER
7137: )
7138: IS
7139: SELECT khr.pdt_id
7140: FROM okl_k_headers_v khr
7141: WHERE khr.ID = p_khr_id;
7142:
7143: -- Cursor to get the distribution for the transaction id and
7144: -- transaction table

Line 8638: FROM okl_k_headers_v A,

8634: p_khr_id IN NUMBER
8635: )
8636: IS
8637: SELECT A.pdt_id, A.MULTI_GAAP_YN, B.REPORTING_PDT_ID
8638: FROM okl_k_headers_v A,
8639: okl_products B
8640: WHERE A.ID = p_khr_id
8641: AND B.ID = A.pdt_id; -- MGAAP 7263041
8642: