VIEW: APPS.OKL_K_FEE_LINES_UV

Source

View Text - Preformatted

SELECT KLEB.FEE_TYPE FEE_TYPE, FNDV.MEANING, KLEB.FEE_PURPOSE_CODE FEE_PURPOSE_CODE, CLEB.ID LINE_ID, CLEB.CLE_ID LINE_CLE_ID, CLEB.STS_CODE LINE_STS_CODE, CLEB.CURRENCY_CODE LINE_CURRENCY_CODE, CLEB.LINE_NUMBER LINE_LINE_NUMBER, CLEB.DISPLAY_SEQUENCE LINE_DISPLAY_SEQUENCE, CLEB.LSE_ID LINE_LSE_ID, CLEB.START_DATE LINE_START_DATE, CLEB.END_DATE LINE_END_DATE, KLEB.AMOUNT LINE_AMOUNT, KLEB.CAPITAL_AMOUNT LINE_CAPITAL_AMOUNT, CLEB.DNZ_CHR_ID LINE_DNZ_CHR_ID, CLEB.CHR_ID LINE_CHR_ID, ITEM.ID ITEM_ID, ITEM.CLE_ID ITEM_CLE_ID, ITEM.OBJECT1_ID1 ITEM_OBJECT1_ID1, ITEM.OBJECT1_ID2 ITEM_OBJECT1_ID2, ITEM.JTOT_OBJECT1_CODE ITEM_JTOT_OBJECT1_CODE, ITEM.CHR_ID ITEM_CHR_ID, ITEM.DNZ_CHR_ID ITEM_DNZ_CHR_ID, ITEM.UOM_CODE ITEM_UOM_CODE, ITEM.EXCEPTION_YN ITEM_EXCEPTION_YN, ITEM.NUMBER_OF_ITEMS ITEM_NUMBER_OF_ITEMS, LSEB.LTY_CODE LS_LTY_CODE, LSEB.ID LS_ID, CPLB.ID PARTY_ID, CPLB.RLE_CODE PARTY_RLE_CODE, CPLB.CLE_ID PARTY_CLE_ID, CPLB.OBJECT1_ID1 PARTY_OBJECT1_ID1, CPLB.OBJECT1_ID2 PARTY_OBJECT1_ID2, CPLB.JTOT_OBJECT1_CODE PARTY_JTOT_OBJECT1_CODE, CPLB.DNZ_CHR_ID PARTY_DNZ_CHR_ID, CHRB.CUST_ACCT_ID CUST_ACCT_ID, KLEB.QTE_ID QTE_ID, TO_NUMBER(NULL) ROLLOVER_QUOTE, TO_CHAR(NULL) CONTRACT_NUMBER, KHRB.KHR_ID KHR_ID, KLEB.attribute_category attribute_category, KLEB.attribute1 attribute1, KLEB.attribute2 attribute2, KLEB.attribute3 attribute3, KLEB.attribute4 attribute4, KLEB.attribute5 attribute5 , KLEB.attribute6 attribute6, KLEB.attribute7 attribute7, KLEB.attribute8 attribute8, KLEB.attribute9 attribute9, KLEB.attribute10 attribute10, KLEB.attribute11 attribute11, KLEB.attribute12 attribute12, KLEB.attribute13 attribute13, KLEB.attribute14 attribute14, KLEB.attribute15 attribute15 FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLEB,OKC_LINE_STYLES_B LSEB,OKC_K_ITEMS ITEM,OKC_K_PARTY_ROLES_B CPLB,FND_LOOKUPS FNDV,OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHRB WHERE CHRB.ID = KHRB.ID AND CHRB.ID = CLEB.DNZ_CHR_ID AND KLEB.ID = CLEB.ID AND CLEB.LSE_ID = LSEB.ID AND LSEB.LTY_CODE = 'FEE' AND ITEM.CLE_ID = CLEB.ID AND CLEB.ID = CPLB.CLE_ID(+) AND CLEB.DNZ_CHR_ID = CPLB.DNZ_CHR_ID(+) AND ITEM.DNZ_CHR_ID = CLEB.DNZ_CHR_ID AND FNDV.LOOKUP_TYPE = 'OKL_FEE_TYPES' AND FNDV.LOOKUP_CODE = KLEB.FEE_TYPE

View Text - HTML Formatted

SELECT KLEB.FEE_TYPE FEE_TYPE
, FNDV.MEANING
, KLEB.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, CLEB.ID LINE_ID
, CLEB.CLE_ID LINE_CLE_ID
, CLEB.STS_CODE LINE_STS_CODE
, CLEB.CURRENCY_CODE LINE_CURRENCY_CODE
, CLEB.LINE_NUMBER LINE_LINE_NUMBER
, CLEB.DISPLAY_SEQUENCE LINE_DISPLAY_SEQUENCE
, CLEB.LSE_ID LINE_LSE_ID
, CLEB.START_DATE LINE_START_DATE
, CLEB.END_DATE LINE_END_DATE
, KLEB.AMOUNT LINE_AMOUNT
, KLEB.CAPITAL_AMOUNT LINE_CAPITAL_AMOUNT
, CLEB.DNZ_CHR_ID LINE_DNZ_CHR_ID
, CLEB.CHR_ID LINE_CHR_ID
, ITEM.ID ITEM_ID
, ITEM.CLE_ID ITEM_CLE_ID
, ITEM.OBJECT1_ID1 ITEM_OBJECT1_ID1
, ITEM.OBJECT1_ID2 ITEM_OBJECT1_ID2
, ITEM.JTOT_OBJECT1_CODE ITEM_JTOT_OBJECT1_CODE
, ITEM.CHR_ID ITEM_CHR_ID
, ITEM.DNZ_CHR_ID ITEM_DNZ_CHR_ID
, ITEM.UOM_CODE ITEM_UOM_CODE
, ITEM.EXCEPTION_YN ITEM_EXCEPTION_YN
, ITEM.NUMBER_OF_ITEMS ITEM_NUMBER_OF_ITEMS
, LSEB.LTY_CODE LS_LTY_CODE
, LSEB.ID LS_ID
, CPLB.ID PARTY_ID
, CPLB.RLE_CODE PARTY_RLE_CODE
, CPLB.CLE_ID PARTY_CLE_ID
, CPLB.OBJECT1_ID1 PARTY_OBJECT1_ID1
, CPLB.OBJECT1_ID2 PARTY_OBJECT1_ID2
, CPLB.JTOT_OBJECT1_CODE PARTY_JTOT_OBJECT1_CODE
, CPLB.DNZ_CHR_ID PARTY_DNZ_CHR_ID
, CHRB.CUST_ACCT_ID CUST_ACCT_ID
, KLEB.QTE_ID QTE_ID
, TO_NUMBER(NULL) ROLLOVER_QUOTE
, TO_CHAR(NULL) CONTRACT_NUMBER
, KHRB.KHR_ID KHR_ID
, KLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KLEB.ATTRIBUTE1 ATTRIBUTE1
, KLEB.ATTRIBUTE2 ATTRIBUTE2
, KLEB.ATTRIBUTE3 ATTRIBUTE3
, KLEB.ATTRIBUTE4 ATTRIBUTE4
, KLEB.ATTRIBUTE5 ATTRIBUTE5
, KLEB.ATTRIBUTE6 ATTRIBUTE6
, KLEB.ATTRIBUTE7 ATTRIBUTE7
, KLEB.ATTRIBUTE8 ATTRIBUTE8
, KLEB.ATTRIBUTE9 ATTRIBUTE9
, KLEB.ATTRIBUTE10 ATTRIBUTE10
, KLEB.ATTRIBUTE11 ATTRIBUTE11
, KLEB.ATTRIBUTE12 ATTRIBUTE12
, KLEB.ATTRIBUTE13 ATTRIBUTE13
, KLEB.ATTRIBUTE14 ATTRIBUTE14
, KLEB.ATTRIBUTE15 ATTRIBUTE15
FROM OKC_K_LINES_B CLEB
, OKL_K_LINES KLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS ITEM
, OKC_K_PARTY_ROLES_B CPLB
, FND_LOOKUPS FNDV
, OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHRB
WHERE CHRB.ID = KHRB.ID
AND CHRB.ID = CLEB.DNZ_CHR_ID
AND KLEB.ID = CLEB.ID
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'FEE'
AND ITEM.CLE_ID = CLEB.ID
AND CLEB.ID = CPLB.CLE_ID(+)
AND CLEB.DNZ_CHR_ID = CPLB.DNZ_CHR_ID(+)
AND ITEM.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND FNDV.LOOKUP_TYPE = 'OKL_FEE_TYPES'
AND FNDV.LOOKUP_CODE = KLEB.FEE_TYPE