APPS.OKL_AM_QUOTES_WF dependencies on OKL_TXL_QUOTE_LINES_V

Line 386: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE

382: KHR.contract_number contract_number,
383: TRQ.last_updated_by last_updated_by
384: FROM OKC_K_HEADERS_B KHR,
385: OKL_TRX_QUOTES_V TRQ,
386: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE
387: WHERE KHR.id = TRQ.khr_id
388: AND QTE.qte_id = TRQ.id
389: AND TRQ.id = p_id;
390:

Line 1063: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE

1059: TRQ.comments comments,
1060: TRQ.last_updated_by last_updated_by
1061: FROM OKC_K_HEADERS_B KHR,
1062: OKL_TRX_QUOTES_V TRQ,
1063: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE
1064: WHERE KHR.id = TRQ.khr_id
1065: AND QTE.qte_id = TRQ.id
1066: AND TRQ.id = p_id;
1067:

Line 1848: FROM OKL_TXL_QUOTE_LINES_V a

1844: -- Check quote exists
1845: CURSOR get_agent_id_csr ( p_qte_id IN VARCHAR2)
1846: IS
1847: SELECT a.LAST_UPDATED_BY LAST_UPDATED_BY
1848: FROM OKL_TXL_QUOTE_LINES_V a
1849: WHERE a.qte_id = to_number(p_qte_id);
1850:
1851: CURSOR c_vendor(p_vendor_id IN NUMBER)
1852: IS

Line 2326: FROM okl_txl_quote_lines_v a

2322: l_init_msg_list VARCHAR2(1) := 'T';
2323:
2324: CURSOR c_requestor(p_quote_id IN NUMBER) is
2325: SELECT a.last_updated_by last_update_by
2326: FROM okl_txl_quote_lines_v a
2327: WHERE a.qte_id = p_quote_id;
2328:
2329: ERR EXCEPTION;
2330: l_batch_id NUMBER;

Line 2843: FROM OKL_TXL_QUOTE_LINES_V a

2839: -- Check quote exists
2840: CURSOR get_agent_id_csr ( p_qte_id IN NUMBER)
2841: IS
2842: SELECT a.LAST_UPDATED_BY LAST_UPDATED_BY
2843: FROM OKL_TXL_QUOTE_LINES_V a
2844: WHERE a.qte_id = p_qte_id;
2845: -- ansethur 26-jul-2007 R12B XMLP End changes
2846: -- for debug logging
2847: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'chk_pre_proceeds_title_noti';

Line 3205: FROM OKL_TXL_QUOTE_LINES_V

3201: -- Cursor to get the sum of the amounts of all quote lines for the quote ( for a asset)
3202: /* CURSOR l_sum_amt_csr ( p_qte_id IN NUMBER) IS
3203: SELECT SUM(amount) total_amount,
3204: kle_id kle_id
3205: FROM OKL_TXL_QUOTE_LINES_V
3206: WHERE qte_id = p_qte_id
3207: AND qlt_code <> 'AMCTAX'
3208: GROUP BY kle_id;
3209: */

Line 3213: FROM OKL_TXL_QUOTE_LINES_V

3209: */
3210:
3211: CURSOR l_amt_csr ( p_qte_id IN NUMBER) IS
3212: SELECT nvl(amount,0) amount, kle_id -- SECHAWLA 11-MAR-03 : nvl the amount
3213: FROM OKL_TXL_QUOTE_LINES_V
3214: WHERE qte_id = p_qte_id
3215: AND qlt_code = 'AMBSPR' ;
3216:
3217: --SECHAWLA 11-MAR-03 : Added the following cursor

Line 3222: FROM OKL_TXL_QUOTE_LINES_V

3218: -- This cursor is used when there are no quote lines of type 'AMBSPR'. In this case 0 is passed as proceeds_of_sale
3219: -- to Asset Disposition
3220: CURSOR l_quotelines_csr( p_qte_id IN NUMBER) IS
3221: SELECT DISTINCT kle_id
3222: FROM OKL_TXL_QUOTE_LINES_V
3223: WHERE qte_id = p_qte_id;
3224:
3225: -- RRAVIKIR Legal Entity Changes
3226: CURSOR fetch_art_id(cp_qte_id IN NUMBER) IS

Line 3483: OKL_TXL_QUOTE_LINES_V qlt

3479: CURSOR l_return_csr ( p_qte_id IN NUMBER) IS
3480: SELECT QLT.kle_id kle_id,
3481: RET.id ret_id
3482: FROM OKL_ASSET_RETURNS_V ret,
3483: OKL_TXL_QUOTE_LINES_V qlt
3484: WHERE RET.kle_id = QLT.kle_id
3485: AND QLT.qte_id = p_qte_id
3486: AND QLT.qlt_code <> 'AMCTAX'
3487: GROUP BY QLT.kle_id, RET.id;

Line 3634: FROM OKL_TXL_QUOTE_LINES_V

3630: /*
3631: -- Get the quote amount
3632: CURSOR okl_get_qte_amt_csr(p_qte_id IN NUMBER) IS
3633: SELECT SUM(amount)
3634: FROM OKL_TXL_QUOTE_LINES_V
3635: WHERE qte_id = p_qte_id;
3636: */
3637:
3638: -- RMUNJULU 09-MAY-03 2949544

Line 4076: FROM OKL_TXL_QUOTE_LINES_V a,

4072: SELECT a.LAST_UPDATED_BY LAST_UPDATED_BY,
4073: a.QTE_ID QTE_ID,
4074: b.PO_PARTY_ID1 QP_PARTY_ID,
4075: decode(b.po_party_object, 'OKX_OPERUNIT', 'O', 'OKX_PARTY', 'P', 'OKX_VENDOR', 'V') party_type
4076: FROM OKL_TXL_QUOTE_LINES_V a,
4077: OKL_AM_QUOTE_PARTIES_UV b
4078: WHERE a.qte_id = to_number(p_qte_id)
4079: -- and b.qp_role_code = 'RECIPIENT'
4080: and b.quote_id = a.qte_id;

Line 4866: FROM OKL_TXL_QUOTE_LINES_V a,

4862: SELECT a.LAST_UPDATED_BY LAST_UPDATED_BY,
4863: a.QTE_ID QTE_ID,
4864: b.PO_PARTY_ID1 QP_PARTY_ID,
4865: decode(b.po_party_object, 'OKX_OPERUNIT', 'O', 'OKX_PARTY', 'P', 'OKX_VENDOR', 'V') party_type
4866: FROM OKL_TXL_QUOTE_LINES_V a,
4867: OKL_AM_QUOTE_PARTIES_UV b
4868: WHERE a.qte_id = to_number(p_qte_id)
4869: -- and b.qp_role_code = 'RECIPIENT'
4870: and b.quote_id = a.qte_id;

Line 7562: OKL_TXL_QUOTE_LINES_V txl,

7558: , kle.ITEM_DESCRIPTION ASSET_NUMBER
7559: , txl.ASSET_QUANTITY ASSET_QUANTITY
7560: , txl.QUOTE_QUANTITY QUOTE_QUANTITY
7561: FROM OKL_TRX_QUOTES_V trx,
7562: OKL_TXL_QUOTE_LINES_V txl,
7563: OKC_K_HEADERS_V khr,
7564: OKC_K_LINES_V kle
7565: WHERE trx.id = p_qte_id
7566: and txl.qte_id (+) = trx.id