DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on OKC_K_HEADERS_B

Line 384: FROM OKC_K_HEADERS_B KHR,

380: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
381: TRQ.comments comments,
382: KHR.contract_number contract_number,
383: TRQ.last_updated_by last_updated_by
384: FROM OKC_K_HEADERS_B KHR,
385: OKL_TRX_QUOTES_V TRQ,
386: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE
387: WHERE KHR.id = TRQ.khr_id
388: AND QTE.qte_id = TRQ.id

Line 1061: FROM OKC_K_HEADERS_B KHR,

1057: OKL_AM_UTIL_PVT.get_chr_currency(TRQ.khr_id) currency,
1058: KHR.contract_number contract_number,
1059: TRQ.comments comments,
1060: TRQ.last_updated_by last_updated_by
1061: FROM OKC_K_HEADERS_B KHR,
1062: OKL_TRX_QUOTES_V TRQ,
1063: (SELECT SUM(NVL(amount,0)) amount, qte_id FROM OKL_TXL_QUOTE_LINES_V GROUP BY qte_id) QTE
1064: WHERE KHR.id = TRQ.khr_id
1065: AND QTE.qte_id = TRQ.id

Line 5456: OKC_K_HEADERS_B KHR

5452: TRX.KHR_ID,
5453: TRX.QTP_CODE,
5454: KHR.CONTRACT_NUMBER
5455: FROM OKL_TRX_QUOTES_B TRX,
5456: OKC_K_HEADERS_B KHR
5457: WHERE TRX.id = p_qte_id
5458: AND TRX.KHR_ID = KHR.ID;
5459:
5460:

Line 8469: OKC_K_HEADERS_B KHR

8465: TRX.KHR_ID,
8466: TRX.QTP_CODE,
8467: KHR.CONTRACT_NUMBER
8468: FROM OKL_TRX_QUOTES_B TRX,
8469: OKC_K_HEADERS_B KHR
8470: WHERE TRX.id = p_qte_id
8471: AND TRX.KHR_ID = KHR.ID;
8472:
8473: -- Cursor to obtain quote amount