AR_BPA_CONTENT_AREAS

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
ROW_ID URL_ID CONTENT_AREA_ID DISPLAY_LEVEL CONTENT_TYPE CONTENT_ORIENTATION TEMPLATE_ID CONTENT_STYLE_ID ITEM_ID DISPLAY_SEQUENCE CONTENT_AREA_WIDTH CONTENT_AREA_LEFT_SPACE CONTENT_AREA_RIGHT_SPACE CONTENT_AREA_TOP_SPACE CONTENT_AREA_BOTTOM_SPACE CONTENT_COUNT LAST_UPDATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LINE_REGION_FLAG CREATED_BY ITEM_LABEL_STYLE ITEM_VALUE_STYLE CONTENT_DISP_PROMPT_STYLE INVOICE_LINE_TYPE AREA_CODE PARENT_AREA_CODE CONTENT_AREA_NAME CONTENT_DISPLAY_PROMPT ITEM_COLUMN_WIDTH

Name

ROW_ID

URL_ID

CONTENT_AREA_ID

DISPLAY_LEVEL

CONTENT_TYPE

CONTENT_ORIENTATION

TEMPLATE_ID

CONTENT_STYLE_ID

ITEM_ID

DISPLAY_SEQUENCE

CONTENT_AREA_WIDTH

CONTENT_AREA_LEFT_SPACE

CONTENT_AREA_RIGHT_SPACE

CONTENT_AREA_TOP_SPACE

CONTENT_AREA_BOTTOM_SPACE

CONTENT_COUNT

LAST_UPDATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LINE_REGION_FLAG

CREATED_BY

ITEM_LABEL_STYLE

ITEM_VALUE_STYLE

CONTENT_DISP_PROMPT_STYLE

INVOICE_LINE_TYPE

AREA_CODE

PARENT_AREA_CODE

CONTENT_AREA_NAME

CONTENT_DISPLAY_PROMPT

ITEM_COLUMN_WIDTH

Query

SQL_Statement
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')

SQL_Statement

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')