[Home] [Help] [Dependency Information]
Object Name: | AR_BPA_AREA_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_BPA_AREA_ITEMS |
Subobject Name: | |
Status: | VALID |
The AR_BPA_AREA_ITEMS table stores the selected content items for each template defined in Bill Presentment Architecture. The selected items are chosen in the shuttle boxes of the Select Content and Layout and Select Content pages. Each row includes the content items and corresponding templates.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_BPA_AREA_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TEMPLATE_ID
PARENT_AREA_CODE DISPLAY_LEVEL ITEM_ID |
AR_BPA_AREA_ITEMS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AREA_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AREA_ITEM_ID | NUMBER | (15) | Yes | Primary Key column |
TEMPLATE_ID | NUMBER | (15) | Yes | Identifies template that the rule belongs to. Foreign key to the AR_BPA_TEMPLATES_B table. |
PARENT_AREA_CODE | VARCHAR2 | (30) | Yes | Identifies which content area was split to form the new content area |
DISPLAY_LEVEL | VARCHAR2 | (30) | Yes | Identifies level in the page at which data is displayed |
SECONDARY_APP_ID | NUMBER | (15) | Yes | Supplementary application for data |
ITEM_ID | NUMBER | (15) | Yes | Identifies the item that the attribute is associated with. Foreign key to the AR_BPA_ITEMS_B table. |
DISPLAY_SEQUENCE | NUMBER | Yes | Order in which contents are displayed | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
DATA_SOURCE_ID | NUMBER | (15) | Identifies data source of the area item | |
FLEXFIELD_ITEM_FLAG | VARCHAR2 | (1) | Indicates if item is a flexfield item |
Cut, paste (and edit) the following text to query this object:
SELECT AREA_ITEM_ID
, TEMPLATE_ID
, PARENT_AREA_CODE
, DISPLAY_LEVEL
, SECONDARY_APP_ID
, ITEM_ID
, DISPLAY_SEQUENCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DATA_SOURCE_ID
, FLEXFIELD_ITEM_FLAG
FROM AR.AR_BPA_AREA_ITEMS;
AR.AR_BPA_AREA_ITEMS does not reference any database object
AR.AR_BPA_AREA_ITEMS is referenced by following:
|
|
|