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_TRX_QUOTES_B

Line 180: OKL_TRX_QUOTES_B qte

176: CURSOR get_assets_in_k_csr (p_qte_id IN NUMBER) IS
177: SELECT kle.id asset_id
178: FROM OKC_K_LINES_B kle,
179: OKC_LINE_STYLES_B LSEB,
180: OKL_TRX_QUOTES_B qte
181: WHERE kle.chr_id = qte.khr_id
182: AND kle.STS_CODE <> 'ABANDONED'
183: AND KLE.LSE_ID = LSEB.ID
184: AND LSEB.LTY_CODE = 'FREE_FORM1'

Line 200: OKL_TRX_QUOTES_B qte

196: CURSOR get_k_assets_no_csr ( p_qte_id IN NUMBER) IS
197: SELECT COUNT(KLE.id) CONTRACT_ASSETS
198: FROM OKC_K_LINES_B kle,
199: OKC_LINE_STYLES_B LSEB,
200: OKL_TRX_QUOTES_B qte
201: WHERE kle.chr_id = qte.khr_id
202: AND kle.STS_CODE <> 'ABANDONED'
203: AND KLE.LSE_ID = LSEB.ID
204: AND LSEB.LTY_CODE = 'FREE_FORM1'

Line 845: FROM okl_trx_quotes_b otqv,

841: clet.item_description asset_description,
842: clet.name asset_number,
843: oalv.serial_number serial_number,
844: oalv.model_number model_number
845: FROM okl_trx_quotes_b otqv,
846: okl_txl_qte_lines_all_b tql,
847: okc_k_lines_b cleb,
848: okc_k_lines_tl clet,
849: okx_asset_lines_v oalv,

Line 2040: FROM OKL_TRX_QUOTES_B

2036:
2037: -- Get the quote khr_id
2038: CURSOR c_qte_csr(c_id NUMBER) IS
2039: SELECT khr_id, qtp_code
2040: FROM OKL_TRX_QUOTES_B
2041: WHERE id = c_id;
2042:
2043: -- for debug logging
2044: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'chk_pre_proceeds_bill_of_sale';

Line 3228: FROM OKL_TRX_QUOTES_B

3224:
3225: -- RRAVIKIR Legal Entity Changes
3226: CURSOR fetch_art_id(cp_qte_id IN NUMBER) IS
3227: SELECT art_id
3228: FROM OKL_TRX_QUOTES_B
3229: WHERE id = cp_qte_id;
3230:
3231: CURSOR fetch_legal_entity_id(cp_art_id IN NUMBER) IS
3232: SELECT legal_entity_id

Line 4825: FROM OKL_TRX_QUOTES_B a,

4821: -- Changed CURSOR get_quote_csr SQL definition
4822: CURSOR get_quote_csr ( p_qte_id IN VARCHAR2)
4823: IS
4824: SELECT a.last_updated_by, a.quote_number, count(*) recs
4825: FROM OKL_TRX_QUOTES_B a,
4826: OKL_QUOTE_PARTIES b
4827: WHERE a.id = p_qte_id
4828: and a.qst_code in ('DRAFTED', 'REJECTED')
4829: and b.qte_id (+) = a.id

Line 5326: FROM OKL_TRX_QUOTES_B

5322: l_rgd_code VARCHAR2(30);
5323:
5324: CURSOR c_qte_csr(c_id NUMBER) IS
5325: SELECT partial_yn, khr_id, qtp_code
5326: FROM OKL_TRX_QUOTES_B
5327: WHERE id = c_id;
5328:
5329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5330: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 5457: FROM OKL_TRX_QUOTES_B TRX,

5453: TRX.QUOTE_NUMBER,
5454: TRX.KHR_ID,
5455: TRX.QTP_CODE,
5456: KHR.CONTRACT_NUMBER
5457: FROM OKL_TRX_QUOTES_B TRX,
5458: OKC_K_HEADERS_B KHR
5459: WHERE TRX.id = p_qte_id
5460: AND TRX.KHR_ID = KHR.ID;
5461:

Line 5583: FROM OKL_TRX_QUOTES_B

5579:
5580: --Rkuttiya 18-SEP-2003 added "last_updated by" column to the following cursor for bug 2794685
5581: CURSOR c_qte_csr(c_id NUMBER) IS
5582: SELECT khr_id, qtp_code,last_updated_by
5583: FROM OKL_TRX_QUOTES_B
5584: WHERE id = c_id;
5585:
5586: CURSOR c_qtl_csr(c_id NUMBER) IS
5587: SELECT *

Line 7170: FROM OKL_TRX_QUOTES_B a,

7166: -- Changed CURSOR get_quote_csr SQL definition
7167: CURSOR get_quote_csr ( p_qte_id IN VARCHAR2)
7168: IS
7169: SELECT a.last_updated_by, a.quote_number
7170: FROM OKL_TRX_QUOTES_B a,
7171: okl_quote_parties b
7172: WHERE a.id = p_qte_id
7173: and a.qst_code in ('ACCEPTED')
7174: and b.qte_id (+) = a.id;

Line 7968: FROM OKL_TRX_QUOTES_B qte

7964: -- rmunjulu EDAT -- get quote dates
7965: CURSOR get_quote_values_csr (p_qte_id IN NUMBER) IS
7966: SELECT qte.date_effective_from,
7967: qte.date_accepted
7968: FROM OKL_TRX_QUOTES_B qte
7969: WHERE qte.id = p_qte_id;
7970:
7971: l_quote_eff_date DATE;
7972: l_quote_accpt_date DATE;

Line 8318: FROM OKL_TRX_QUOTES_B

8314: resultout OUT NOCOPY VARCHAR2) IS
8315: -- Get the quote details
8316: CURSOR c_qte_csr(c_id NUMBER) IS
8317: SELECT khr_id, qtp_code,last_updated_by
8318: FROM OKL_TRX_QUOTES_B
8319: WHERE id = c_id;
8320:
8321: -- Get the quote BASE amount
8322: CURSOR c_qtl_csr(c_id NUMBER) IS

Line 8470: FROM OKL_TRX_QUOTES_B TRX,

8466: TRX.QUOTE_NUMBER,
8467: TRX.KHR_ID,
8468: TRX.QTP_CODE,
8469: KHR.CONTRACT_NUMBER
8470: FROM OKL_TRX_QUOTES_B TRX,
8471: OKC_K_HEADERS_B KHR
8472: WHERE TRX.id = p_qte_id
8473: AND TRX.KHR_ID = KHR.ID;
8474:

Line 8573: FROM OKL_TRX_QUOTES_B

8569: resultout OUT NOCOPY VARCHAR2) IS
8570:
8571: CURSOR check_repo_csr(p_qte_id IN NUMBER) IS
8572: SELECT repo_quote_indicator_yn
8573: FROM OKL_TRX_QUOTES_B
8574: WHERE id = p_qte_id;
8575:
8576: l_id NUMBER;
8577: l_repo_yn VARCHAR2(1);

Line 8653: FROM OKL_TRX_QUOTES_B

8649: AND ARS_CODE <> 'CANCELLED';
8650:
8651: CURSOR c_khr_csr(p_qte_id IN NUMBER) IS
8652: SELECT khr_id
8653: FROM OKL_TRX_QUOTES_B
8654: WHERE ID = p_qte_id;
8655:
8656: CURSOR c_system_options(p_org_id IN NUMBER) IS
8657: SELECT B.NAME