VIEW: AR.AR_BPA_ITEMS_B#

Source

View Text - Preformatted

select ITEM_ID ITEM_ID, ITEM_CODE ITEM_CODE, ITEM_SOURCE ITEM_SOURCE, ITEM_TYPE ITEM_TYPE, DISPLAY_LEVEL DISPLAY_LEVEL, DATA_SOURCE_ID DATA_SOURCE_ID, DISPLAY_ENABLED_FLAG DISPLAY_ENABLED_FLAG, ASSIGNMENT_ENABLED_FLAG ASSIGNMENT_ENABLED_FLAG, AMOUNT_ITEM_FLAG AMOUNT_ITEM_FLAG, URL_ID URL_ID, ITEM_IMAGE_FILENAME ITEM_IMAGE_FILENAME, ITEM_MESSAGE_NAME ITEM_MESSAGE_NAME, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DISPLAYED_MULTI_LEVEL_FLAG DISPLAYED_MULTI_LEVEL_FLAG, SEEDED_APPLICATION_ID SEEDED_APPLICATION_ID, TAX_ITEM_FLAG TAX_ITEM_FLAG, TOTALS_ENABLED_FLAG TOTALS_ENABLED_FLAG, LINK_ENABLED_FLAG LINK_ENABLED_FLAG, DATA_TYPE DATA_TYPE, URLCFG_ENABLED_FLAG URLCFG_ENABLED_FLAG, FLEXFIELD_ITEM_FLAG FLEXFIELD_ITEM_FLAG, COLUMN_NAME COLUMN_NAME, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."AR_BPA_ITEMS_B"

View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, ITEM_CODE ITEM_CODE
, ITEM_SOURCE ITEM_SOURCE
, ITEM_TYPE ITEM_TYPE
, DISPLAY_LEVEL DISPLAY_LEVEL
, DATA_SOURCE_ID DATA_SOURCE_ID
, DISPLAY_ENABLED_FLAG DISPLAY_ENABLED_FLAG
, ASSIGNMENT_ENABLED_FLAG ASSIGNMENT_ENABLED_FLAG
, AMOUNT_ITEM_FLAG AMOUNT_ITEM_FLAG
, URL_ID URL_ID
, ITEM_IMAGE_FILENAME ITEM_IMAGE_FILENAME
, ITEM_MESSAGE_NAME ITEM_MESSAGE_NAME
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DISPLAYED_MULTI_LEVEL_FLAG DISPLAYED_MULTI_LEVEL_FLAG
, SEEDED_APPLICATION_ID SEEDED_APPLICATION_ID
, TAX_ITEM_FLAG TAX_ITEM_FLAG
, TOTALS_ENABLED_FLAG TOTALS_ENABLED_FLAG
, LINK_ENABLED_FLAG LINK_ENABLED_FLAG
, DATA_TYPE DATA_TYPE
, URLCFG_ENABLED_FLAG URLCFG_ENABLED_FLAG
, FLEXFIELD_ITEM_FLAG FLEXFIELD_ITEM_FLAG
, COLUMN_NAME COLUMN_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."AR_BPA_ITEMS_B"