[Home] [Help] [Dependency Information]
Object Name: | AX_DISTRIB_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | AX |
FND Design Data: | AX.AX_DISTRIB_HEADERS |
Subobject Name: | |
Status: | VALID |
This table stores information about the distribution headers of a
translation scheme. It contains a row for each distribution header.
Each row includes the number of the distribution header within the
translation scheme, the header column that it populates, the query
chain used and the source table and column.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AX_DISTRIB_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
APPLICATION_ID TRANSLATION_SCHEME HEADER_NUMBER |
AX_DISTRIB_HEADERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
QUERY_CHAIN_NAME |
Table | |
Foreign Table | Foreign Key Column | AX_DISTRIB_HEADERS | AX_TRANS_SCHEMES |
AX_DISTRIB_HEADERS
SET_OF_BOOKS_ID
AX_DISTRIB_HEADERS APPLICATION_ID AX_DISTRIB_HEADERS TRANSLATION_SCHEME |
AX_CONDITIONS | AX_DISTRIB_HEADERS |
AX_CONDITIONS
SET_OF_BOOKS_ID
AX_CONDITIONS APPLICATION_ID AX_CONDITIONS TRANSLATION_SCHEME AX_CONDITIONS HEADER_NUMBER |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | Yes | Set of books identifier | |
APPLICATION_ID | NUMBER | Yes | Application identifier | |
TRANSLATION_SCHEME | VARCHAR2 | (30) | Yes | Translation scheme name |
HEADER_NUMBER | NUMBER | Yes | Distribution header number | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
HEADER_COLUMN | VARCHAR2 | (30) | Yes | Header column name |
QUERY_CHAIN_NAME | VARCHAR2 | (30) | Query chain name used | |
SOURCE_TABLE | VARCHAR2 | (30) | Query chain table name | |
SOURCE_COLUMN | VARCHAR2 | (30) | Yes | Query chain table column name |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, APPLICATION_ID
, TRANSLATION_SCHEME
, HEADER_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, HEADER_COLUMN
, QUERY_CHAIN_NAME
, SOURCE_TABLE
, SOURCE_COLUMN
FROM AX.AX_DISTRIB_HEADERS;
AX.AX_DISTRIB_HEADERS does not reference any database object
AX.AX_DISTRIB_HEADERS is referenced by following:
|
|
|