VIEW: APPS.AMS_CELLS_VL

Source

View Text - Preformatted

SELECT b.rowid row_id, b.cell_id, t.cell_name, t.description, b.last_update_date, b.last_updated_by, b.creation_date, b.created_by, b.last_update_login, b.cell_code, b.OWNER_ID, b.market_segment_flag, b.enabled_flag, b.original_size, b.parent_cell_id, b.object_version_number, b.SEL_TYPE, b.STATUS_CODE, b.STATUS_DATE, b.USER_STATUS_ID, b.country from ams_cells_all_tl t, ams_cells_all_b b WHERE b.cell_id = t.cell_id and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.CELL_ID
, T.CELL_NAME
, T.DESCRIPTION
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CELL_CODE
, B.OWNER_ID
, B.MARKET_SEGMENT_FLAG
, B.ENABLED_FLAG
, B.ORIGINAL_SIZE
, B.PARENT_CELL_ID
, B.OBJECT_VERSION_NUMBER
, B.SEL_TYPE
, B.STATUS_CODE
, B.STATUS_DATE
, B.USER_STATUS_ID
, B.COUNTRY
FROM AMS_CELLS_ALL_TL T
, AMS_CELLS_ALL_B B
WHERE B.CELL_ID = T.CELL_ID
AND T.LANGUAGE = USERENV('LANG')