eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_BPA_CONTENT_AREAS_B

Object Details

Object Name:	AR_BPA_CONTENT_AREAS_B
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_BPA_CONTENT_AREAS_B
Subobject Name:
Status:	VALID

Release 11i: Used by Bill Presentment Architecture

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_BPA_CONTENT_AREAS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTENT_AREA_ID
AR_BPA_CONTENT_AREAS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID DISPLAY_LEVEL
AR_BPA_CONTENT_AREAS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTENT_AREA_ID	NUMBER	(15)	Yes	Unique identifier of content area
DISPLAY_LEVEL	VARCHAR2	(30)	Yes	Identifies level in the page at which data is displayed
CONTENT_TYPE	NUMBER		Yes	Indicates type of content such as sub-region,text,image, message or address
CONTENT_ORIENTATION	NUMBER			Identifies vertical or horizontal orientation of content referenced in the content area
TEMPLATE_ID	NUMBER	(15)	Yes	Identifies template to which the content area belongs
CONTENT_STYLE_ID	NUMBER	(15)		Indicates layout style of the content
ITEM_ID	NUMBER	(15)		Foreign key to items registered for display in HTML page
URL_ID	NUMBER	(15)		Identifies HTML page linked to the item
DISPLAY_SEQUENCE	NUMBER		Yes	Order in which contents are displayed
CONTENT_AREA_WIDTH	VARCHAR2	(80)		Percent width of the content area
CONTENT_AREA_LEFT_SPACE	NUMBER			F Space to the left of contents in pixels
CONTENT_AREA_RIGHT_SPACE	NUMBER			Space to the right of contents in pixels
CONTENT_AREA_TOP_SPACE	NUMBER			Space above the contents in pixels
CONTENT_AREA_BOTTOM_SPACE	NUMBER			Space below the contents in pixels
CONTENT_COUNT	NUMBER			Number of items referenced from this content area
LINE_REGION_FLAG	VARCHAR2	(1)		Flag to indicate if the content area displays transaction lines
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ITEM_LABEL_STYLE	VARCHAR2	(30)		Display style of the item label.
CONTENT_DISP_PROMPT_STYLE	VARCHAR2	(30)		Display style of the content area display prompt
ITEM_VALUE_STYLE	VARCHAR2	(30)		Display style of the item value
INVOICE_LINE_TYPE	VARCHAR2	(30)		Identifies the invoice line type
AREA_CODE	VARCHAR2	(30)		Unique identifier of content area
PARENT_AREA_CODE	VARCHAR2	(30)		Identifies which content area was split to form the new content
ITEM_COLUMN_WIDTH	NUMBER	(15)		Column Width for Item

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTENT_AREA_ID
,      DISPLAY_LEVEL
,      CONTENT_TYPE
,      CONTENT_ORIENTATION
,      TEMPLATE_ID
,      CONTENT_STYLE_ID
,      ITEM_ID
,      URL_ID
,      DISPLAY_SEQUENCE
,      CONTENT_AREA_WIDTH
,      CONTENT_AREA_LEFT_SPACE
,      CONTENT_AREA_RIGHT_SPACE
,      CONTENT_AREA_TOP_SPACE
,      CONTENT_AREA_BOTTOM_SPACE
,      CONTENT_COUNT
,      LINE_REGION_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ITEM_LABEL_STYLE
,      CONTENT_DISP_PROMPT_STYLE
,      ITEM_VALUE_STYLE
,      INVOICE_LINE_TYPE
,      AREA_CODE
,      PARENT_AREA_CODE
,      ITEM_COLUMN_WIDTH
FROM AR.AR_BPA_CONTENT_AREAS_B;

Dependencies

[top of page]

AR.AR_BPA_CONTENT_AREAS_B does not reference any database object

AR.AR_BPA_CONTENT_AREAS_B is referenced by following:

APPS: AR_BPA_CONTENT_AREAS_B