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 4695: OKL_TXL_QUOTE_LINES_B OTL,

4691: OTQ.COMMENTS COMMENTS,
4692: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4693: OTQ.KHR_ID KHR_ID
4694: FROM OKL_TRX_QUOTES_V OTQ,
4695: OKL_TXL_QUOTE_LINES_B OTL,
4696: OKC_K_HEADERS_V AD
4697: WHERE OTQ.ID = c_id
4698: AND OTQ.ID = OTL.QTE_ID
4699: AND AD.ID = OTQ.KHR_ID

Line 5197: OKL_TXL_QUOTE_LINES_B OTL,

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

Line 5586: FROM OKL_TXL_QUOTE_LINES_B

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

Line 6687: FROM OKL_TXL_QUOTE_LINES_B

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

Line 8322: FROM OKL_TXL_QUOTE_LINES_B

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

Line 8476: FROM OKL_TXL_QUOTE_LINES_B TQL

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