DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKL_TRX_QUOTES_V

Line 2970: FROM OKL_TRX_QUOTES_V QTE,

2966: KHR.contract_number contract_number,
2967: QTE.partial_yn partial_yn,
2968: QTE.qst_code qst_code,
2969: QTE.qtp_code qtp_code
2970: FROM OKL_TRX_QUOTES_V QTE,
2971: OKC_K_HEADERS_V KHR
2972: WHERE QTE.khr_id = KHR.id
2973: AND NVL(QTE.accepted_yn,'N') = 'Y'
2974: AND NVL(QTE.consolidated_yn,'N') = 'N' -- non consolidated

Line 3055: FROM OKL_TRX_QUOTES_V QTE,

3051: KHR.contract_number contract_number,
3052: QTE.partial_yn partial_yn,
3053: QTE.qst_code qst_code,
3054: QTE.qtp_code qtp_code
3055: FROM OKL_TRX_QUOTES_V QTE,
3056: OKL_TXL_QUOTE_LINES_V TQL,
3057: OKC_K_LINES_V KLE,
3058: OKC_K_HEADERS_V KHR
3059: WHERE TQL.kle_id = KLE.id

Line 3346: FROM OKL_TRX_QUOTES_V QTE,

3342: KHR.contract_number contract_number,
3343: QTE.partial_yn partial_yn,
3344: QTE.qst_code qst_code,
3345: QTE.qtp_code qtp_code
3346: FROM OKL_TRX_QUOTES_V QTE,
3347: OKC_K_HEADERS_V KHR
3348: WHERE QTE.khr_id = KHR.id
3349: AND NVL(QTE.accepted_yn,'N') = 'Y'
3350: AND QTE.qtp_code LIKE 'TER%' -- ansethur 07-aug-2007 Added for bug 5932098