DBA Data[Home] [Help]

APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 3882: okl_txl_quote_lines_b tql

3878: )
3879: IS
3880: SELECT cle.ID cle_id
3881: FROM okc_k_lines_b cle,
3882: okl_txl_quote_lines_b tql
3883: WHERE tql.qte_id = p_qte_id
3884: AND tql.qlt_code = 'AMCFIA'
3885: AND tql.kle_id = cle.ID
3886: UNION

Line 3891: okl_txl_quote_lines_b tql,

3887: SELECT DISTINCT hdrcle.ID cle_id
3888: FROM okc_k_lines_b cle,
3889: okc_k_lines_b hdrcle,
3890: okc_k_items cim,
3891: okl_txl_quote_lines_b tql,
3892: okc_k_headers_b CHR,
3893: okc_line_styles_b lse
3894: WHERE hdrcle.chr_id = p_chr_id
3895: AND cle.cle_id = hdrcle.ID

Line 7999: FROM okl_txl_quote_lines_b qlt

7995: p_qte_id IN NUMBER
7996: )
7997: IS
7998: SELECT qlt.kle_id
7999: FROM okl_txl_quote_lines_b qlt
8000: WHERE qlt.qlt_code = 'AMCFIA' AND qlt.qte_id = p_qte_id;
8001:
8002: l_counter NUMBER;
8003:

Line 9627: FROM okl_txl_quote_lines_b

9623: IS
9624: SELECT ID tql_id,
9625: asset_quantity asset_quantity,
9626: quote_quantity quote_quantity
9627: FROM okl_txl_quote_lines_b
9628: WHERE qte_id = cp_qte_id
9629: AND qlt_code = 'AMCFIA'
9630: AND kle_id = cp_kle_id;
9631: