VIEW: APPS.OKL_CS_FEE_PAYMENT_SUMMARY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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