DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 670: ,okl_txl_quote_lines_b tql

666: SELECT qte.quote_number quote_number
667: ,qte.date_accepted quote_accepted_date
668: ,qte.qtp_code quote_type
669: FROM okl_trx_quotes_all_b qte
670: ,okl_txl_quote_lines_b tql
671: WHERE qte.id = tql.qte_id
672: AND qte.qst_code in ('ACCEPTED', 'COMPLETE')
673: AND qte.accepted_yn = 'Y'
674: AND tql.qlt_code = 'AMCFIA'

Line 685: ,okl_txl_quote_lines_b tql

681: SELECT qte.quote_number quote_number
682: ,qte.date_accepted quote_accepted_date
683: ,qte.qtp_code quote_type
684: FROM okl_trx_quotes_all_b qte
685: ,okl_txl_quote_lines_b tql
686: WHERE qte.id = tql.qte_id
687: AND qte.qst_code in ('ACCEPTED', 'COMPLETE')
688: AND qte.accepted_yn = 'Y'
689: AND tql.qlt_code = 'AMCFIA'

Line 732: ,okl_txl_quote_lines_b qtl

728:
729: FROM okl_trx_types_b trx_b
730: ,okl_trx_contracts_all rel_trx
731: ,okl_trx_quotes_all_b qte
732: ,okl_txl_quote_lines_b qtl
733: WHERE trx_b.trx_type_class = 'TERMINATION'
734: AND trx_b.id = rel_trx.try_id
735: AND rel_trx.khr_id = p_khr_id
736: AND qte.qst_code in ( 'ACCEPTED', 'COMPLETE')