VIEW: APPS.OKL_BPD_LATE_POLICIES_UV

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, STAT.NAME LOCATION, LPOB.TDF_ID TDF_ID, LPOB.IDX_ID IDX_ID, INDS.NAME IDX_NAME, LPOB.LATE_POLICY_TYPE_CODE LATE_POLICY_TYPE_CODE, LPOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LPOB.LATE_CHRG_AMOUNT LATE_CHRG_AMOUNT, LPOB.LATE_CHRG_RATE LATE_CHRG_RATE, LPOB.LATE_INT_RATE LATE_INT_RATE FROM OKL_LATE_POLICIES_B LPOB,OKL_LATE_POLICIES_TL LPOT,OKX_STATES_V STAT,OKL_INDICES INDS WHERE LPOB.ID = LPOT.ID AND LPOB.ISE_ID = STAT.ID1 AND LPOB.IDX_ID = INDS.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
, STAT.NAME LOCATION
, LPOB.TDF_ID TDF_ID
, LPOB.IDX_ID IDX_ID
, INDS.NAME IDX_NAME
, LPOB.LATE_POLICY_TYPE_CODE LATE_POLICY_TYPE_CODE
, LPOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LPOB.LATE_CHRG_AMOUNT LATE_CHRG_AMOUNT
, LPOB.LATE_CHRG_RATE LATE_CHRG_RATE
, LPOB.LATE_INT_RATE LATE_INT_RATE
FROM OKL_LATE_POLICIES_B LPOB
, OKL_LATE_POLICIES_TL LPOT
, OKX_STATES_V STAT
, OKL_INDICES INDS
WHERE LPOB.ID = LPOT.ID
AND LPOB.ISE_ID = STAT.ID1
AND LPOB.IDX_ID = INDS.ID(+)
AND LPOT.LANGUAGE = USERENV('LANG')