[Home] [Help] [Dependency Information]
Object Name: | JA_CN_DFF_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_CN_DFF_ASSIGNMENTS |
Subobject Name: | |
Status: | VALID |
The table 'JA_CN_DFF_ASSIGNMENTS' stores context codes and column names for all Descriptive Flexfield used by CNAO programs. Each row includes the application id and descriptive flexfield name, which can identify one Descriptive Flexfiled. There is another column 'DFF_TITLE_CODE' in this table, it stores codes from a lookup that used to define translatable description for DFFs shown in this table. So 'DFF_TITLE_CODE' has one to one relationship with the combination of 'APPLICATION_ID' and 'DESCRIPTIVE_FLEXFIELD_NAME'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_CN_DFF_ASSIGNMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CHART_OF_ACCOUNTS_ID
DFF_TITLE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (10) | Yes | Application identifier |
DESCRIPTIVE_FLEXFIELD_NAME | VARCHAR2 | (40) | Yes | Descriptive flexfield name |
DFF_TITLE_CODE | VARCHAR2 | (30) | Yes | Lookup code for DFF title |
CONTEXT_CODE | VARCHAR2 | (30) | Context code of DFF | |
ATTRIBUTE_COLUMN | VARCHAR2 | (30) | One of columns defined for context of DFF | |
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 | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | Identifier of Chart of Accounts |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, DESCRIPTIVE_FLEXFIELD_NAME
, DFF_TITLE_CODE
, CONTEXT_CODE
, ATTRIBUTE_COLUMN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CHART_OF_ACCOUNTS_ID
FROM JA.JA_CN_DFF_ASSIGNMENTS;
JA.JA_CN_DFF_ASSIGNMENTS does not reference any database object
JA.JA_CN_DFF_ASSIGNMENTS is referenced by following:
|
|
|