VIEW: APPS.IBW_PAGES_VL

Source

View Text - Preformatted

SELECT b.rowid row_id, b.page_id page_id, b.page_code page_code, b.page_status page_status , b.application_context application_context, b.business_context business_context, b.reference reference, b.page_matching_criteria page_matching_criteria, b.site_area_id site_area_id, b.page_matching_value page_matching_value, b.created_by created_by, b.creation_date creation_date, b.last_updated_by last_updated_by, b.last_update_date last_update_date, b.last_update_login last_update_login, b.object_version_number object_version_number, b.program_id program_id, b.program_login_id program_login_id, b.program_application_id program_application_id, b.request_id request_id, l.page_name page_name, l.description description FROM ibw_pages_b b, ibw_pages_tl l WHERE b.page_id=l.page_id AND l.language=USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PAGE_ID PAGE_ID
, B.PAGE_CODE PAGE_CODE
, B.PAGE_STATUS PAGE_STATUS
, B.APPLICATION_CONTEXT APPLICATION_CONTEXT
, B.BUSINESS_CONTEXT BUSINESS_CONTEXT
, B.REFERENCE REFERENCE
, B.PAGE_MATCHING_CRITERIA PAGE_MATCHING_CRITERIA
, B.SITE_AREA_ID SITE_AREA_ID
, B.PAGE_MATCHING_VALUE PAGE_MATCHING_VALUE
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.PROGRAM_ID PROGRAM_ID
, B.PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, B.REQUEST_ID REQUEST_ID
, L.PAGE_NAME PAGE_NAME
, L.DESCRIPTION DESCRIPTION
FROM IBW_PAGES_B B
, IBW_PAGES_TL L
WHERE B.PAGE_ID=L.PAGE_ID
AND L.LANGUAGE=USERENV('LANG')