VIEW: APPS.AR_BPA_ITEMS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.ITEM_ID, B.ITEM_CODE, B.ITEM_SOURCE, B.ITEM_TYPE, B.DISPLAY_LEVEL, B.DATA_SOURCE_ID, B.DISPLAY_ENABLED_FLAG, B.ASSIGNMENT_ENABLED_FLAG, B.AMOUNT_ITEM_FLAG, B.URL_ID, B.ITEM_IMAGE_FILENAME, B.ITEM_MESSAGE_NAME, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.DISPLAYED_MULTI_LEVEL_FLAG, B.SEEDED_APPLICATION_ID, B.TAX_ITEM_FLAG, B.TOTALS_ENABLED_FLAG, B.LINK_ENABLED_FLAG, B.DATA_TYPE, B.URLCFG_ENABLED_FLAG, B.FLEXFIELD_ITEM_FLAG, B.COLUMN_NAME, T.ITEM_NAME, T.ITEM_TEXT_VALUE, T.DISPLAY_PROMPT, T.ITEM_DESCRIPTION from AR_BPA_ITEMS_TL T, AR_BPA_ITEMS_B B WHERE B.ITEM_ID = T.ITEM_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.ITEM_ID
, B.ITEM_CODE
, B.ITEM_SOURCE
, B.ITEM_TYPE
, B.DISPLAY_LEVEL
, B.DATA_SOURCE_ID
, B.DISPLAY_ENABLED_FLAG
, B.ASSIGNMENT_ENABLED_FLAG
, B.AMOUNT_ITEM_FLAG
, B.URL_ID
, B.ITEM_IMAGE_FILENAME
, B.ITEM_MESSAGE_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.DISPLAYED_MULTI_LEVEL_FLAG
, B.SEEDED_APPLICATION_ID
, B.TAX_ITEM_FLAG
, B.TOTALS_ENABLED_FLAG
, B.LINK_ENABLED_FLAG
, B.DATA_TYPE
, B.URLCFG_ENABLED_FLAG
, B.FLEXFIELD_ITEM_FLAG
, B.COLUMN_NAME
, T.ITEM_NAME
, T.ITEM_TEXT_VALUE
, T.DISPLAY_PROMPT
, T.ITEM_DESCRIPTION
FROM AR_BPA_ITEMS_TL T
, AR_BPA_ITEMS_B B
WHERE B.ITEM_ID = T.ITEM_ID
AND T.LANGUAGE = USERENV('LANG')