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

TABLE: AP.AP_WEB_ACCFLEX_SEGMENTS

Object Details
Object Name: AP_WEB_ACCFLEX_SEGMENTS
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_WEB_ACCFLEX_SEGMENTS
Subobject Name:
Status: VALID


This table stores the segment display code and segment number for each segment that is associated with a chart of accounts. The table is not org specific.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_WEB_ACCFLEX_SEGMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID_FLEX_NUM
ColumnAPPLICATION_COLUMN_NAME
ColumnSET_OF_BOOKS_ID
AP_WEB_ACCFLEX_SEGMENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID_FLEX_NUM
ColumnSEGMENT_NUM
ColumnSET_OF_BOOKS_ID
AP_WEB_ACCFLEX_SEGMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnID_FLEX_NUM
ColumnSEGMENT_DISPLAY_CODE
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
ID_FLEX_NUM NUMBER (15) Yes Chart of Accounts ID.
APPLICATION_COLUMN_NAME VARCHAR2 (30) Yes Application Column Name.
SEGMENT_NUM NUMBER (3) Yes Segment Number.
SEGMENT_DISPLAY_CODE VARCHAR2 (30)
Determines display behavior for segment.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
CREATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
SET_OF_BOOKS_ID NUMBER (15) Yes Set Of Books Id
Query Text

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


SELECT ID_FLEX_NUM
,      APPLICATION_COLUMN_NAME
,      SEGMENT_NUM
,      SEGMENT_DISPLAY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
FROM AP.AP_WEB_ACCFLEX_SEGMENTS;

Dependencies

[top of page]

AP.AP_WEB_ACCFLEX_SEGMENTS does not reference any database object

AP.AP_WEB_ACCFLEX_SEGMENTS is referenced by following:

SchemaAPPS
SynonymAP_WEB_ACCFLEX_SEGMENTS