[Home] [Help]
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')
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')
|
|
|
|