DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 1655: ,okl_k_headers_full_v khr

1651: ,khr.currency_conversion_type currency_conversion_type
1652: ,khr.currency_conversion_date currency_conversion_date
1653: ,khr.scs_code
1654: FROM okl_products_v pdt
1655: ,okl_k_headers_full_v khr
1656: WHERE khr.id = p_contract_id
1657: AND khr.pdt_id = pdt.id;
1658:
1659: -- Get the product type

Line 1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1661: SELECT description
1662: FROM OKL_PRODUCTS_V
1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1662: FROM OKL_PRODUCTS_V
1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);

Line 1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);
1671: l_contract_currency_code VARCHAR2(15);

Line 1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);
1671: l_contract_currency_code VARCHAR2(15);
1672: l_converted_amount NUMBER;

Line 1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);
1671: l_contract_currency_code VARCHAR2(15);
1672: l_converted_amount NUMBER;
1673: l_Product_rec Product_csr%ROWTYPE;

Line 5855: FROM okl_k_headers_full_v khrv,

5851: khrv.currency_conversion_type,
5852: khrv.currency_conversion_rate,
5853: khrv.currency_conversion_date,
5854: khrv.start_date
5855: FROM okl_k_headers_full_v khrv,
5856: okc_k_lines_b cle
5857: WHERE khrv.id = cle.dnz_chr_id
5858: AND cle.id = PCleId;
5859: