VIEW: APPS.AR_BPA_CONTENT_AREAS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.URL_ID, B.CONTENT_AREA_ID, B.DISPLAY_LEVEL, B.CONTENT_TYPE, B.CONTENT_ORIENTATION, B.TEMPLATE_ID, B.CONTENT_STYLE_ID, B.ITEM_ID, B.DISPLAY_SEQUENCE, B.CONTENT_AREA_WIDTH, B.CONTENT_AREA_LEFT_SPACE, B.CONTENT_AREA_RIGHT_SPACE, B.CONTENT_AREA_TOP_SPACE, B.CONTENT_AREA_BOTTOM_SPACE, B.CONTENT_COUNT, B.LAST_UPDATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.LINE_REGION_FLAG, B.CREATED_BY, B.ITEM_LABEL_STYLE, B.ITEM_VALUE_STYLE, B.CONTENT_DISP_PROMPT_STYLE, B.INVOICE_LINE_TYPE, B.AREA_CODE, B.PARENT_AREA_CODE, T.CONTENT_AREA_NAME, T.CONTENT_DISPLAY_PROMPT, B.ITEM_COLUMN_WIDTH from AR_BPA_CONTENT_AREAS_TL T, AR_BPA_CONTENT_AREAS_B B WHERE B.CONTENT_AREA_ID = T.CONTENT_AREA_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.URL_ID
, B.CONTENT_AREA_ID
, B.DISPLAY_LEVEL
, B.CONTENT_TYPE
, B.CONTENT_ORIENTATION
, B.TEMPLATE_ID
, B.CONTENT_STYLE_ID
, B.ITEM_ID
, B.DISPLAY_SEQUENCE
, B.CONTENT_AREA_WIDTH
, B.CONTENT_AREA_LEFT_SPACE
, B.CONTENT_AREA_RIGHT_SPACE
, B.CONTENT_AREA_TOP_SPACE
, B.CONTENT_AREA_BOTTOM_SPACE
, B.CONTENT_COUNT
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.LINE_REGION_FLAG
, B.CREATED_BY
, B.ITEM_LABEL_STYLE
, B.ITEM_VALUE_STYLE
, B.CONTENT_DISP_PROMPT_STYLE
, B.INVOICE_LINE_TYPE
, B.AREA_CODE
, B.PARENT_AREA_CODE
, T.CONTENT_AREA_NAME
, T.CONTENT_DISPLAY_PROMPT
, B.ITEM_COLUMN_WIDTH
FROM AR_BPA_CONTENT_AREAS_TL T
, AR_BPA_CONTENT_AREAS_B B
WHERE B.CONTENT_AREA_ID = T.CONTENT_AREA_ID
AND T.LANGUAGE = USERENV('LANG')