DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 1683: ,okl_k_headers_full_v khr

1679: ,khr.currency_conversion_type currency_conversion_type
1680: ,khr.currency_conversion_date currency_conversion_date
1681: ,khr.scs_code
1682: FROM okl_products_v pdt
1683: ,okl_k_headers_full_v khr
1684: WHERE khr.id = p_contract_id
1685: AND khr.pdt_id = pdt.id;
1686:
1687: -- Get the product type

Line 1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1689: SELECT description
1690: FROM OKL_PRODUCTS_V
1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1690: FROM OKL_PRODUCTS_V
1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);

Line 1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);
1699: l_contract_currency_code VARCHAR2(15);

Line 1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);
1699: l_contract_currency_code VARCHAR2(15);
1700: l_converted_amount NUMBER;

Line 1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);
1699: l_contract_currency_code VARCHAR2(15);
1700: l_converted_amount NUMBER;
1701: l_Product_rec Product_csr%ROWTYPE;

Line 5883: FROM okl_k_headers_full_v khrv,

5879: khrv.currency_conversion_type,
5880: khrv.currency_conversion_rate,
5881: khrv.currency_conversion_date,
5882: khrv.start_date
5883: FROM okl_k_headers_full_v khrv,
5884: okc_k_lines_b cle
5885: WHERE khrv.id = cle.dnz_chr_id
5886: AND cle.id = PCleId;
5887: