View: OKL_BPD_CASH_RL_SUMRY_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_CASH_RL_SUMRY_UV

View Text

SELECT B.ID ID
, A.NAME NAME
, A.DESCRIPTION DESCRIPTION
, B.START_DATE START_DATE
, B.END_DATE END_DATE
, B.DEFAULT_RULE DEFAULT_RULE
, A.ORG_ID ORG_ID
FROM OKL_CASH_ALLCTN_RLS_ALL B
, OKL_CSH_ALLCTN_RL_HDR A
WHERE A.ID = B.CAU_ID
AND ((START_DATE <= TRUNC(SYSDATE)
AND END_DATE >= TRUNC(SYSDATE)) OR (START_DATE > TRUNC(SYSDATE)
AND END_DATE > TRUNC(SYSDATE)) OR (START_DATE <= TRUNC(SYSDATE)
AND END_DATE IS NULL) OR (START_DATE >= TRUNC(SYSDATE)
AND END_DATE IS NULL) ) ORDER BY NAME
, START_DATE DESC

Columns