APPS.OKL_AM_QUOTES_WF dependencies on OKL_TXL_QUOTE_LINES_B

Line 1229: OKL_TXL_QUOTE_LINES_B OTL,

1225: TO_CHAR(OTQ.CREATION_DATE, 'DD-MON-RRRR') QUOTE_CREATION_DATE,
1226: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1227: OTQ.comments COMMENTS
1228: FROM OKL_TRX_QUOTES_V OTQ,
1229: OKL_TXL_QUOTE_LINES_B OTL,
1230: OKC_K_HEADERS_V KHR
1231: WHERE OTQ.ID = p_qte_id
1232: AND OTQ.ID = OTL.QTE_ID
1233: AND KHR.ID = OTQ.KHR_ID

Line 3642: FROM okl_txl_quote_lines_b qlt,

3638: -- RMUNJULU 09-MAY-03 2949544
3639: -- Returns Quote Line which needs invoice creation
3640: CURSOR l_qlt_csr (p_qte_id IN NUMBER) IS
3641: SELECT qlt.kle_id kle_id
3642: FROM okl_txl_quote_lines_b qlt,
3643: fnd_lookups flo
3644: WHERE qlt.qte_id = p_qte_id
3645: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)
3646: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'

Line 3659: FROM okl_txl_quote_lines_b qlt,

3655: -- get the quote elements also excluding Estimated Billing Adjustment
3656: -- as it is not billed as part of partial termination quote
3657: CURSOR l_partial_qlt_csr (p_qte_id IN NUMBER) IS
3658: SELECT qlt.kle_id kle_id
3659: FROM okl_txl_quote_lines_b qlt,
3660: fnd_lookups flo
3661: WHERE qlt.qte_id = p_qte_id
3662: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)
3663: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'

Line 4358: OKL_TXL_QUOTE_LINES_B OTL,

4354: OTQ.COMMENTS COMMENTS,
4355: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4356: OTQ.KHR_ID KHR_ID
4357: FROM OKL_TRX_QUOTES_V OTQ,
4358: OKL_TXL_QUOTE_LINES_B OTL,
4359: OKL_QUOTE_PARTIES QP,
4360: OKC_K_PARTY_ROLES_V PR,
4361: OKC_K_HEADERS_ALL_B AD
4362: WHERE OTQ.ID = c_id

Line 4696: OKL_TXL_QUOTE_LINES_B OTL,

4692: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4693: OTQ.KHR_ID KHR_ID
4694: ,OTQ.gain_loss gain_loss -- Added for bug 12802662
4695: FROM OKL_TRX_QUOTES_V OTQ,
4696: OKL_TXL_QUOTE_LINES_B OTL,
4697: OKC_K_HEADERS_V AD
4698: WHERE OTQ.ID = c_id
4699: AND OTQ.ID = OTL.QTE_ID
4700: AND AD.ID = OTQ.KHR_ID

Line 5199: OKL_TXL_QUOTE_LINES_B OTL,

5195: OTQ.COMMENTS COMMENTS,
5196: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
5197: OTQ.KHR_ID KHR_ID
5198: FROM OKL_TRX_QUOTES_V OTQ,
5199: OKL_TXL_QUOTE_LINES_B OTL,
5200: OKC_K_HEADERS_V AD
5201: WHERE OTQ.ID = c_id
5202: AND OTQ.ID = OTL.QTE_ID
5203: AND AD.ID = OTQ.KHR_ID

Line 5588: FROM OKL_TXL_QUOTE_LINES_B

5584: WHERE id = c_id;
5585:
5586: CURSOR c_qtl_csr(c_id NUMBER) IS
5587: SELECT *
5588: FROM OKL_TXL_QUOTE_LINES_B
5589: WHERE qte_id =c_id;
5590:
5591: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5592: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 6689: FROM OKL_TXL_QUOTE_LINES_B

6685:
6686: --rkuttiya 17-SEP-2003 commented for bug 2794685
6687: /* CURSOR c_qtl_csr(c_id NUMBER) IS
6688: SELECT *
6689: FROM OKL_TXL_QUOTE_LINES_B
6690: WHERE qte_id =c_id;
6691: */
6692: l_id NUMBER;
6693: l_partial_yn VARCHAR2(1);

Line 8324: FROM OKL_TXL_QUOTE_LINES_B

8320:
8321: -- Get the quote BASE amount
8322: CURSOR c_qtl_csr(c_id NUMBER) IS
8323: SELECT sum(amount) amount
8324: FROM OKL_TXL_QUOTE_LINES_B
8325: WHERE qte_id =c_id
8326: AND qlt_code NOT IN ('AMCFIA','AMYOUB','BILL_ADJST');
8327:
8328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 8478: FROM OKL_TXL_QUOTE_LINES_B TQL

8474:
8475: -- Cursor to obtain quote amount
8476: CURSOR l_quote_amt_csr ( p_qte_id IN NUMBER) IS
8477: SELECT nvl(SUM(amount),0) amount
8478: FROM OKL_TXL_QUOTE_LINES_B TQL
8479: WHERE TQL.qte_id = p_qte_id
8480: AND TQL.qlt_code NOT IN ('AMCFIA','AMYOUB','BILL_ADJST');
8481:
8482: