VIEW: APPS.OKL_LATE_POLICIES_V

Source

View Text - Preformatted

SELECT LPOB.ROWID ROW_ID,LPOB.ID ID,LPOB.ORG_ID ORG_ID,LPOT.NAME NAME,LPOT.DESCRIPTION DESCRIPTION,LPOB.ISE_ID ISE_ID,LPOB.TDF_ID TDF_ID, LPOB.IDX_ID IDX_ID,LPOB.LATE_POLICY_TYPE_CODE LATE_POLICY_TYPE_CODE,LPOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LPOB.LATE_CHRG_ALLOWED_YN LATE_CHRG_ALLOWED_YN,LPOB.LATE_CHRG_FIXED_YN LATE_CHRG_FIXED_YN,LPOB.LATE_CHRG_AMOUNT LATE_CHRG_AMOUNT, LPOB.LATE_CHRG_RATE LATE_CHRG_RATE,LPOB.LATE_CHRG_GRACE_PERIOD LATE_CHRG_GRACE_PERIOD,LPOB.LATE_CHRG_MINIMUM_BALANCE LATE_CHRG_MINIMUM_BALANCE, LPOB.MINIMUM_LATE_CHARGE MINIMUM_LATE_CHARGE,LPOB.MAXIMUM_LATE_CHARGE MAXIMUM_LATE_CHARGE,LPOB.LATE_INT_ALLOWED_YN LATE_INT_ALLOWED_YN, LPOB.LATE_INT_FIXED_YN LATE_INT_FIXED_YN,LPOB.LATE_INT_RATE LATE_INT_RATE,LPOB.ADDER_RATE ADDER_RATE,LPOB.LATE_INT_GRACE_PERIOD LATE_INT_GRACE_PERIOD, LPOB.LATE_INT_MINIMUM_BALANCE LATE_INT_MINIMUM_BALANCE,LPOB.MINIMUM_LATE_INTEREST MINIMUM_LATE_INTEREST, LPOB.MAXIMUM_LATE_INTEREST MAXIMUM_LATE_INTEREST, LPOB.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM, LPOB.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO, LPOB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, LPOB.ATTRIBUTE1 ATTRIBUTE1, LPOB.ATTRIBUTE2 ATTRIBUTE2,LPOB.ATTRIBUTE3 ATTRIBUTE3,LPOB.ATTRIBUTE4 ATTRIBUTE4,LPOB.ATTRIBUTE5 ATTRIBUTE5, LPOB.ATTRIBUTE6 ATTRIBUTE6,LPOB.ATTRIBUTE7 ATTRIBUTE7,LPOB.ATTRIBUTE8 ATTRIBUTE8,LPOB.ATTRIBUTE9 ATTRIBUTE9, LPOB.ATTRIBUTE10 ATTRIBUTE10,LPOB.ATTRIBUTE11 ATTRIBUTE11,LPOB.ATTRIBUTE12 ATTRIBUTE12,LPOB.ATTRIBUTE13 ATTRIBUTE13, LPOB.ATTRIBUTE14 ATTRIBUTE14,LPOB.ATTRIBUTE15 ATTRIBUTE15,LPOB.CREATED_BY CREATED_BY,LPOB.CREATION_DATE CREATION_DATE, LPOB.LAST_UPDATED_BY LAST_UPDATED_BY,LPOB.LAST_UPDATE_DATE LAST_UPDATE_DATE,LPOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LPOB.DAYS_IN_YEAR DAYS_IN_YEAR FROM OKL_LATE_POLICIES_B LPOB,OKL_LATE_POLICIES_TL LPOT WHERE LPOB.ID = LPOT.ID and LPOT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT LPOB.ROWID ROW_ID
, LPOB.ID ID
, LPOB.ORG_ID ORG_ID
, LPOT.NAME NAME
, LPOT.DESCRIPTION DESCRIPTION
, LPOB.ISE_ID ISE_ID
, LPOB.TDF_ID TDF_ID
, LPOB.IDX_ID IDX_ID
, LPOB.LATE_POLICY_TYPE_CODE LATE_POLICY_TYPE_CODE
, LPOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LPOB.LATE_CHRG_ALLOWED_YN LATE_CHRG_ALLOWED_YN
, LPOB.LATE_CHRG_FIXED_YN LATE_CHRG_FIXED_YN
, LPOB.LATE_CHRG_AMOUNT LATE_CHRG_AMOUNT
, LPOB.LATE_CHRG_RATE LATE_CHRG_RATE
, LPOB.LATE_CHRG_GRACE_PERIOD LATE_CHRG_GRACE_PERIOD
, LPOB.LATE_CHRG_MINIMUM_BALANCE LATE_CHRG_MINIMUM_BALANCE
, LPOB.MINIMUM_LATE_CHARGE MINIMUM_LATE_CHARGE
, LPOB.MAXIMUM_LATE_CHARGE MAXIMUM_LATE_CHARGE
, LPOB.LATE_INT_ALLOWED_YN LATE_INT_ALLOWED_YN
, LPOB.LATE_INT_FIXED_YN LATE_INT_FIXED_YN
, LPOB.LATE_INT_RATE LATE_INT_RATE
, LPOB.ADDER_RATE ADDER_RATE
, LPOB.LATE_INT_GRACE_PERIOD LATE_INT_GRACE_PERIOD
, LPOB.LATE_INT_MINIMUM_BALANCE LATE_INT_MINIMUM_BALANCE
, LPOB.MINIMUM_LATE_INTEREST MINIMUM_LATE_INTEREST
, LPOB.MAXIMUM_LATE_INTEREST MAXIMUM_LATE_INTEREST
, LPOB.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, LPOB.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, LPOB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LPOB.ATTRIBUTE1 ATTRIBUTE1
, LPOB.ATTRIBUTE2 ATTRIBUTE2
, LPOB.ATTRIBUTE3 ATTRIBUTE3
, LPOB.ATTRIBUTE4 ATTRIBUTE4
, LPOB.ATTRIBUTE5 ATTRIBUTE5
, LPOB.ATTRIBUTE6 ATTRIBUTE6
, LPOB.ATTRIBUTE7 ATTRIBUTE7
, LPOB.ATTRIBUTE8 ATTRIBUTE8
, LPOB.ATTRIBUTE9 ATTRIBUTE9
, LPOB.ATTRIBUTE10 ATTRIBUTE10
, LPOB.ATTRIBUTE11 ATTRIBUTE11
, LPOB.ATTRIBUTE12 ATTRIBUTE12
, LPOB.ATTRIBUTE13 ATTRIBUTE13
, LPOB.ATTRIBUTE14 ATTRIBUTE14
, LPOB.ATTRIBUTE15 ATTRIBUTE15
, LPOB.CREATED_BY CREATED_BY
, LPOB.CREATION_DATE CREATION_DATE
, LPOB.LAST_UPDATED_BY LAST_UPDATED_BY
, LPOB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LPOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LPOB.DAYS_IN_YEAR DAYS_IN_YEAR
FROM OKL_LATE_POLICIES_B LPOB
, OKL_LATE_POLICIES_TL LPOT
WHERE LPOB.ID = LPOT.ID
AND LPOT.LANGUAGE = USERENV('LANG')