DBA Data[Home] [Help]

VIEW: APPS.IBE_MSITE_RESPS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.MSITE_RESP_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.MSITE_ID, B.RESPONSIBILITY_ID, B.APPLICATION_ID, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.SORT_ORDER, T.DISPLAY_NAME , B.GROUP_CODE from IBE_MSITE_RESPS_TL T, IBE_MSITE_RESPS_B B WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.MSITE_RESP_ID
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.MSITE_ID
, B.RESPONSIBILITY_ID
, B.APPLICATION_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.SORT_ORDER
, T.DISPLAY_NAME
, B.GROUP_CODE
FROM IBE_MSITE_RESPS_TL T
, IBE_MSITE_RESPS_B B
WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
AND T.LANGUAGE = USERENV('LANG')