[Home] [Help]
View: OKL_PYMTS_SERVICE_INSTS_UV
Product: | OKL - Lease and Finance Management |
Description: | User Interface view forService Line instance LOV on Payments Page |
Implementation/DBA Data: |
APPS.OKL_PYMTS_SERVICE_INSTS_UV
|
View Text
SELECT KLINES.ID LINE_ID
, KLINES.DNZ_CHR_ID KHR_ID
, KLINES.LSE_ID LSE_ID
, SYSITMS.NAME SERVICE_INST_NAME
, SYSITMS.DESCRIPTION SERVICE_INST_DESC
FROM OKX_SYSTEM_ITEMS_V SYSITMS
, OKC_K_ITEMS KITMS
, OKC_LINE_STYLES_B LSE
, OKC_K_LINES_B KLINES
, OKC_STATUSES_B STS
WHERE SYSITMS.ID1 = KITMS.OBJECT1_ID1
AND TO_CHAR(SYSITMS.ID2) = TO_CHAR(KITMS.OBJECT1_ID2)
AND LSE.ID = KLINES.LSE_ID
AND LSE.LTY_CODE = 'SOLD_SERVICE'
AND KITMS.JTOT_OBJECT1_CODE = 'OKX_SERVICE'
AND KITMS.CLE_ID = KLINES.ID
AND STS.CODE = KLINES.STS_CODE
AND STS.STE_CODE NOT IN ('HOLD'
, 'EXPIRED'
, 'CANCELLED')
AND NOT EXISTS ( SELECT 'Y'
FROM OKC_K_REL_OBJS REL
WHERE REL.CLE_ID = KLINES.ID
AND REL.RTY_CODE = 'OKLSRV'
AND REL.JTOT_OBJECT1_CODE = 'OKL_SERVICE_LINE' )
Columns
Name |
LINE_ID |
KHR_ID |
LSE_ID |
SERVICE_INST_NAME |
SERVICE_INST_DESC |