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 4823: FROM OKL_TRX_QUOTES_B a,

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

Line 5324: FROM OKL_TRX_QUOTES_B

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

Line 5455: FROM OKL_TRX_QUOTES_B TRX,

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

Line 5581: FROM OKL_TRX_QUOTES_B

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

Line 7168: FROM OKL_TRX_QUOTES_B a,

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

Line 7966: FROM OKL_TRX_QUOTES_B qte

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

Line 8316: FROM OKL_TRX_QUOTES_B

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

Line 8468: FROM OKL_TRX_QUOTES_B TRX,

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

Line 8571: FROM OKL_TRX_QUOTES_B

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

Line 8651: FROM OKL_TRX_QUOTES_B

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