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

Line 365: OKL_K_HEADERS_FULL_V K

361: K.contract_number,
362: Q.last_updated_by,
363: Q.created_by
364: FROM OKL_TRX_QUOTES_V Q,
365: OKL_K_HEADERS_FULL_V K
366: WHERE Q.khr_id = K.id
367: AND Q.id = p_quote_id;
368:
369: --PAGARG Bug# 4012492

Line 1392: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

1388: l_term_rec term_rec_type;
1389: l_tcnv_rec tcnv_rec_type;
1390:
1391: l_contract_id NUMBER;
1392: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
1393: l_termination_date DATE;
1394: lx_msg_count NUMBER;
1395: lx_msg_data VARCHAR2(2000);
1396: l_return_status VARCHAR2(1);

Line 2029: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

2025: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2026: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2027: l_rule_found VARCHAR2(1) := 'N';
2028: l_contract_id NUMBER;
2029: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2030:
2031: l_id NUMBER;
2032: l_rule_khr_id NUMBER;
2033: l_qtp_code VARCHAR2(30);

Line 2191: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

2187:
2188:
2189: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2190: l_contract_id NUMBER;
2191: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2192: l_recipient_type VARCHAR2(3);
2193: l_id NUMBER;
2194: l_recipient_code VARCHAR2(200);
2195: l_recipient_id NUMBER;

Line 3090: FROM OKL_K_HEADERS_FULL_V K,

3086: CURSOR okl_pop_contract_details_csr ( p_quote_id IN NUMBER) IS
3087: SELECT K.id,
3088: K.contract_number,
3089: Q.last_updated_by
3090: FROM OKL_K_HEADERS_FULL_V K,
3091: OKL_TRX_QUOTES_V Q
3092: WHERE K.id = Q.khr_id
3093: AND Q.id = p_quote_id;
3094:

Line 3098: l_k_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

3094:
3095: l_transaction_id VARCHAR2(2000);
3096: l_k_id NUMBER;
3097: l_created_by NUMBER;
3098: l_k_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
3099:
3100: l_requester VARCHAR2(200);
3101: l_description VARCHAR2(200);
3102: l_requester_id NUMBER;

Line 8688: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;

8684: l_asset_return_value NUMBER;
8685: /* Bug 6712322 end */
8686: /* Bug 6736148 start */
8687: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
8688: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
8689: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
8690: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
8691: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
8692: lx_converted_amount NUMBER;

Line 8689: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

8685: /* Bug 6712322 end */
8686: /* Bug 6736148 start */
8687: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
8688: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
8689: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
8690: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
8691: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
8692: lx_converted_amount NUMBER;
8693: /* Bug 6736148 end */

Line 8690: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

8686: /* Bug 6736148 start */
8687: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
8688: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
8689: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
8690: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
8691: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
8692: lx_converted_amount NUMBER;
8693: /* Bug 6736148 end */
8694: BEGIN

Line 8691: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

8687: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
8688: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
8689: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
8690: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
8691: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
8692: lx_converted_amount NUMBER;
8693: /* Bug 6736148 end */
8694: BEGIN
8695: