VIEW: APPS.OKL_BPD_ACTIVE_CSH_RLS_V

Source

View Text - Preformatted

SELECT A.ID ID1, '#' ID2, 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_CSH_ALLCTN_RL_HDR A,OKL_CASH_ALLCTN_RLS_ALL B WHERE A.ID = B.CAU_ID AND ((start_date <= trunc(SYSDATE) AND end_date >= trunc(SYSDATE)) OR (start_date <= trunc(SYSDATE) AND end_date IS NULL) ) UNION SELECT -1 ID1, '#' ID2, MEANING NAME, DESCRIPTION, NULL START_DATE, NULL END_DATE, NULL DEFAULT_RULE, NULL ORG_ID FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'OKL_CASH_APPL_RULE' AND LOOKUP_CODE = 'ON_ACCOUNT' ORDER BY NAME, START_DATE DESC

View Text - HTML Formatted

SELECT A.ID ID1
, '#' ID2
, 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_CSH_ALLCTN_RL_HDR A
, OKL_CASH_ALLCTN_RLS_ALL B
WHERE A.ID = B.CAU_ID
AND ((START_DATE <= TRUNC(SYSDATE)
AND END_DATE >= TRUNC(SYSDATE)) OR (START_DATE <= TRUNC(SYSDATE)
AND END_DATE IS NULL) ) UNION SELECT -1 ID1
, '#' ID2
, MEANING NAME
, DESCRIPTION
, NULL START_DATE
, NULL END_DATE
, NULL DEFAULT_RULE
, NULL ORG_ID
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'OKL_CASH_APPL_RULE'
AND LOOKUP_CODE = 'ON_ACCOUNT' ORDER BY NAME
, START_DATE DESC