DBA Data[Home] [Help]

VIEW: APPS.AR_BPA_URLS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.URL_ID, B.URL_ADDRESS, B.FULL_URL_ADDRESS, B.SEEDED_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.DISPLAY_AREA, B.APPLICATION_ID, B.DATA_SOURCE_ID, T.URL_NAME, T.URL_DESCRIPTION from AR_BPA_URLS_TL T, AR_BPA_URLS_B B WHERE B.URL_ID = T.URL_ID and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.URL_ID
, B.URL_ADDRESS
, B.FULL_URL_ADDRESS
, B.SEEDED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.DISPLAY_AREA
, B.APPLICATION_ID
, B.DATA_SOURCE_ID
, T.URL_NAME
, T.URL_DESCRIPTION
FROM AR_BPA_URLS_TL T
, AR_BPA_URLS_B B
WHERE B.URL_ID = T.URL_ID
AND T.LANGUAGE = USERENV('LANG')