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

TABLE: JA.JA_CN_CFS_ITEM_MAPPING_HDRS

Object Details
Object Name: JA_CN_CFS_ITEM_MAPPING_HDRS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JA_CN_CFS_ITEM_MAPPING_HDRS
Subobject Name:
Status: VALID

The table stores the header information for cash flow item mapping. Each row includes Chart of Account ID, application id, event class code, and Supporting Reference code. There is a one-to-many relationship between the cash flow item mapping information stored in the table and cash flow item mapping information stored in table JA_CN_CFS_ITEM_MAPPING_LINES.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JA_CN_CFS_ITEM_MAPPING_HDRS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAPPING_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
MAPPING_HEADER_ID NUMBER
Yes Mapping header id
CHART_OF_ACCOUNTS_ID NUMBER
Yes Key flexfield structure defining column
APPLICATION_ID NUMBER
Yes Internal id of the application
EVENT_CLASS_CODE VARCHAR2 (30)
Event class code
ANALYTICAL_CRITERION_CODE VARCHAR2 (100) Yes Supporting Reference code
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 (1) Yes Analytical Criterion type code
AMB_CONTEXT_CODE VARCHAR2 (30) Yes Accounting methods builder context
EFFECTIVE_START_DATE DATE

Effective start date
EFFECTIVE_END_DATE DATE

Effective end date
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATE_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
Query Text

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


SELECT MAPPING_HEADER_ID
,      CHART_OF_ACCOUNTS_ID
,      APPLICATION_ID
,      EVENT_CLASS_CODE
,      ANALYTICAL_CRITERION_CODE
,      ANALYTICAL_CRITERION_TYPE_CODE
,      AMB_CONTEXT_CODE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JA.JA_CN_CFS_ITEM_MAPPING_HDRS;

Dependencies

[top of page]

JA.JA_CN_CFS_ITEM_MAPPING_HDRS does not reference any database object

JA.JA_CN_CFS_ITEM_MAPPING_HDRS is referenced by following:

SchemaJA
ViewJA_CN_CFS_ITEM_MAPPING_HDRS#