DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKC_K_HEADERS_V

Line 2971: OKC_K_HEADERS_V KHR

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
2975: AND QTE.khr_id = p_khr_id;

Line 3058: OKC_K_HEADERS_V KHR

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
3060: AND TQL.qte_id = QTE.id
3061: AND KLE.chr_id = KHR.id
3062: AND TQL.qlt_code = 'AMCFIA'

Line 3347: OKC_K_HEADERS_V KHR

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
3351: AND NVL(QTE.consolidated_yn,'N') = 'N' -- non consolidated