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_COPY_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 4118: OKL_K_HEADERS_FULL_V KHR

4114: khr.authoring_org_id,
4115: khr.currency_code,
4116: khr.start_date
4117: From OKL_K_LINES_FULL_V kle,
4118: OKL_K_HEADERS_FULL_V KHR
4119: Where kle.id = cleId
4120: and KHR.ID = KLE.DNZ_CHR_ID;
4121:
4122: l_chr_rec l_chr_csr%ROWTYPE;

Line 4123: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

4119: Where kle.id = cleId
4120: and KHR.ID = KLE.DNZ_CHR_ID;
4121:
4122: l_chr_rec l_chr_csr%ROWTYPE;
4123: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4124: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4125:
4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

Line 4124: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

4120: and KHR.ID = KLE.DNZ_CHR_ID;
4121:
4122: l_chr_rec l_chr_csr%ROWTYPE;
4123: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4124: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4125:
4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

4122: l_chr_rec l_chr_csr%ROWTYPE;
4123: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4124: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4125:
4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4129: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4130:

Line 4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

4123: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4124: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4125:
4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4129: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4130:
4131: CURSOR c_check_txl_rec(p_fa_kle_id OKL_K_LINES_V.ID%TYPE)

Line 4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

4124: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
4125:
4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4129: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4130:
4131: CURSOR c_check_txl_rec(p_fa_kle_id OKL_K_LINES_V.ID%TYPE)
4132: IS

Line 4129: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

4125:
4126: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4129: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4130:
4131: CURSOR c_check_txl_rec(p_fa_kle_id OKL_K_LINES_V.ID%TYPE)
4132: IS
4133: SELECT 1

Line 4299: From okl_k_headers_full_v

4295: r_ib_info c_ib_info%ROWTYPE;
4296:
4297: Cursor deal_type_stscode_csr(p_chr_id IN NUMBER) is
4298: Select deal_type, sts_code
4299: From okl_k_headers_full_v
4300: Where id = p_chr_id;
4301:
4302: l_deal_type okl_k_headers_full_v.deal_type%type;
4303: lv_sts_code okl_k_headers_full_v.deal_type%type;

Line 4302: l_deal_type okl_k_headers_full_v.deal_type%type;

4298: Select deal_type, sts_code
4299: From okl_k_headers_full_v
4300: Where id = p_chr_id;
4301:
4302: l_deal_type okl_k_headers_full_v.deal_type%type;
4303: lv_sts_code okl_k_headers_full_v.deal_type%type;
4304:
4305: --Bug# 2981308
4306: --cursor to fetch asset key ccid

Line 4303: lv_sts_code okl_k_headers_full_v.deal_type%type;

4299: From okl_k_headers_full_v
4300: Where id = p_chr_id;
4301:
4302: l_deal_type okl_k_headers_full_v.deal_type%type;
4303: lv_sts_code okl_k_headers_full_v.deal_type%type;
4304:
4305: --Bug# 2981308
4306: --cursor to fetch asset key ccid
4307: cursor l_fab_csr(p_asset_id in number) is