VIEW: APPS.ASG_RESPONSIBILITY_VL

Source

View Text - Preformatted

SELECT distinct a.responsibility_id, b.responsibility_name, b.description from asg_pub_responsibility a, FND_RESPONSIBILITY_VL b WHERE a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID AND pub_id = 'SERVICEP' and to_char(b.START_DATE, 'YYYY-MM-DD')<=to_char(sysdate, 'YYYY-MM-DD') and (b.end_date is null or to_char(b.END_DATE, 'YYYY-MM-DD')>=to_char(sysdate, 'YYYY-MM-DD')) UNION SELECT a.responsibility_id, b.responsibility_name, b.description FROM fnd_responsibility a, FND_RESPONSIBILITY_VL b WHERE a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID AND a.application_id = 513 and to_char(b.START_DATE, 'YYYY-MM-DD')<=to_char(sysdate, 'YYYY-MM-DD') and (b.end_date is null or to_char(b.END_DATE, 'YYYY-MM-DD')>=to_char(sysdate, 'YYYY-MM-DD')) and (a.end_date is null or to_char(a.END_DATE, 'YYYY-MM-DD')>=to_char(sysdate, 'YYYY-MM-DD')) AND nvl(fnd_profile.value_specific('ASG_MOBILE_USER', null, a.responsibility_id, a.application_id ), 'N') = 'Y'

View Text - HTML Formatted

SELECT DISTINCT A.RESPONSIBILITY_ID
, B.RESPONSIBILITY_NAME
, B.DESCRIPTION
FROM ASG_PUB_RESPONSIBILITY A
, FND_RESPONSIBILITY_VL B
WHERE A.RESPONSIBILITY_ID=B.RESPONSIBILITY_ID
AND PUB_ID = 'SERVICEP'
AND TO_CHAR(B.START_DATE
, 'YYYY-MM-DD')<=TO_CHAR(SYSDATE
, 'YYYY-MM-DD')
AND (B.END_DATE IS NULL OR TO_CHAR(B.END_DATE
, 'YYYY-MM-DD')>=TO_CHAR(SYSDATE
, 'YYYY-MM-DD')) UNION SELECT A.RESPONSIBILITY_ID
, B.RESPONSIBILITY_NAME
, B.DESCRIPTION
FROM FND_RESPONSIBILITY A
, FND_RESPONSIBILITY_VL B
WHERE A.RESPONSIBILITY_ID=B.RESPONSIBILITY_ID
AND A.APPLICATION_ID = 513
AND TO_CHAR(B.START_DATE
, 'YYYY-MM-DD')<=TO_CHAR(SYSDATE
, 'YYYY-MM-DD')
AND (B.END_DATE IS NULL OR TO_CHAR(B.END_DATE
, 'YYYY-MM-DD')>=TO_CHAR(SYSDATE
, 'YYYY-MM-DD'))
AND (A.END_DATE IS NULL OR TO_CHAR(A.END_DATE
, 'YYYY-MM-DD')>=TO_CHAR(SYSDATE
, 'YYYY-MM-DD'))
AND NVL(FND_PROFILE.VALUE_SPECIFIC('ASG_MOBILE_USER'
, NULL
, A.RESPONSIBILITY_ID
, A.APPLICATION_ID )
, 'N') = 'Y'