VIEW: APPS.JTF_IH_ACTIVE_ACTION_ITEMS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.ACTION_ITEM_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.ACTION_ITEM, T.SHORT_DESCRIPTION, B.ACTIVE FROM JTF_IH_ACTION_ITEMS_B B, JTF_IH_ACTION_ITEMS_TL T WHERE B.ACTION_ITEM_ID = T.ACTION_ITEM_ID AND B.ACTIVE <> 'N' AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.ACTION_ITEM_ID
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.ACTION_ITEM
, T.SHORT_DESCRIPTION
, B.ACTIVE
FROM JTF_IH_ACTION_ITEMS_B B
, JTF_IH_ACTION_ITEMS_TL T
WHERE B.ACTION_ITEM_ID = T.ACTION_ITEM_ID
AND B.ACTIVE <> 'N'
AND T.LANGUAGE = USERENV('LANG')