VIEW: APPS.OKL_PYMTS_SERVICE_INSTS_UV

Source

View Text - Preformatted

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' )

View Text - HTML Formatted

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' )