VIEW: APPS.OKL_BPD_CASH_RL_SUMRY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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