DBA Data[Home] [Help]

VIEW: APPS.CSD_RT_TRAN_RESPS_V

Source

View Text - Preformatted

SELECT A_RESPS.RT_TRAN_ID RT_TRAN_ID, A_RESPS.RT_TRAN_RESP_ID RT_TRAN_RESP_ID, A_RESPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, RESPS.RESPONSIBILITY_ID RESPONSIBILITY_ID, RESPS.RESPONSIBILITY_NAME RESPONSIBILITY_NAME FROM CSD_RT_TRAN_RESPS A_RESPS, FND_RESPONSIBILITY_TL RESPS WHERE RESPS.RESPONSIBILITY_ID = A_RESPS.RESPONSIBILITY_ID AND RESPS.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT A_RESPS.RT_TRAN_ID RT_TRAN_ID
, A_RESPS.RT_TRAN_RESP_ID RT_TRAN_RESP_ID
, A_RESPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RESPS.RESPONSIBILITY_ID RESPONSIBILITY_ID
, RESPS.RESPONSIBILITY_NAME RESPONSIBILITY_NAME
FROM CSD_RT_TRAN_RESPS A_RESPS
, FND_RESPONSIBILITY_TL RESPS
WHERE RESPS.RESPONSIBILITY_ID = A_RESPS.RESPONSIBILITY_ID
AND RESPS.LANGUAGE = USERENV('LANG')