[Home] [Help]
View: OKL_CS_FEE_PAYMENT_SUMMARY_UV
View Text
SELECT STM.ID STM_ID
, STM.KHR_ID KHR_ID
, STYT.NAME STREAM_TYPE
, STM.STY_ID STY_ID
, NULL ASSET_NUMBER
, CLE.ID KLE_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, LSE.NAME LINE_TYPE
, LSE.LTY_CODE LINE_TYPE_CODE
, STM.SAY_CODE STATUS_CODE
, FND.MEANING STATUS
, OKL_CS_LC_CONTRACT_PVT.GET_TOTAL_STREAM_AMOUNT(STM.KHR_ID
, CLE.ID
, STM.STY_ID) AMOUNT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, KLE.FEE_TYPE FEE_TYPE_CODE
, FND_FEE.MEANING FEE_TYPE
FROM OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STREAMS STM
, OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLE
, OKC_LINE_STYLES_V LSE
, FND_LOOKUPS FND
, OKL_K_LINES KLE
, FND_LOOKUPS FND_FEE
WHERE STM.PURPOSE_CODE IS NULL
AND STM.STY_ID = STYB.ID
AND STYB.ID = STYT.ID
AND STYB.BILLABLE_YN = 'Y'
AND STYT.LANGUAGE = USERENV('LANG')
AND CHRB.ID = STM.KHR_ID
AND CLE.ID(+) = STM.KLE_ID
AND CLE.LSE_ID=LSE.ID(+)
AND LSE.LTY_CODE = 'FEE'
AND FND.LOOKUP_TYPE='OKL_STREAM_ACTIVITY'
AND FND.LOOKUP_CODE=STM.SAY_CODE
AND CLE.ID=KLE.ID
AND FND_FEE.LOOKUP_TYPE='OKL_FEE_TYPES'
AND FND_FEE.LOOKUP_CODE=KLE.FEE_TYPE
Columns
Name |
STM_ID |
KHR_ID |
STREAM_TYPE |
STY_ID |
ASSET_NUMBER |
KLE_ID |
CONTRACT_NUMBER |
LINE_TYPE |
LINE_TYPE_CODE |
STATUS_CODE |
STATUS |
AMOUNT |
CURRENCY_CODE |
FEE_TYPE_CODE |
FEE_TYPE |