DBA Data[Home] [Help]

VIEW: APPS.BSC_RESPONSIBILITY_VL

Source

View Text - Preformatted

SELECT RESPONSIBILITY_ID, RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL WHERE APPLICATION_ID = 271 AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE)
View Text - HTML Formatted

SELECT RESPONSIBILITY_ID
, RESPONSIBILITY_NAME
FROM FND_RESPONSIBILITY_VL
WHERE APPLICATION_ID = 271
AND SYSDATE BETWEEN START_DATE
AND NVL(END_DATE
, SYSDATE)