SELECT A_RESPS.FLWSTS_TRAN_RESP_ID FLWSTS_TRAN_RESP_ID, A_RESPS.FLWSTS_TRAN_ID FLWSTS_TRAN_ID, RESPS.RESPONSIBILITY_ID RESPONSIBILITY_ID, RESPS.RESPONSIBILITY_NAME RESPONSIBILITY_NAME, A_RESPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM CSD_FLWSTS_TRAN_RESPS A_RESPS, FND_RESPONSIBILITY_TL RESPS WHERE RESPS.RESPONSIBILITY_ID = A_RESPS.RESPONSIBILITY_ID AND RESPS.LANGUAGE = USERENV('LANG')
SELECT A_RESPS.FLWSTS_TRAN_RESP_ID FLWSTS_TRAN_RESP_ID
, A_RESPS.FLWSTS_TRAN_ID FLWSTS_TRAN_ID
, RESPS.RESPONSIBILITY_ID RESPONSIBILITY_ID
, RESPS.RESPONSIBILITY_NAME RESPONSIBILITY_NAME
, A_RESPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSD_FLWSTS_TRAN_RESPS A_RESPS
, FND_RESPONSIBILITY_TL RESPS
WHERE RESPS.RESPONSIBILITY_ID = A_RESPS.RESPONSIBILITY_ID
AND RESPS.LANGUAGE = USERENV('LANG')
|
|
|