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

VIEW: APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V

Object Details
Object Name: JA_CN_CFS_ITEM_MAPPING_HDRS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.JA_CN_CFS_ITEM_MAPPING_HDRS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MAPPING_HEADER_ID NUMBER
Yes
CHART_OF_ACCOUNTS_ID NUMBER
Yes
APPLICATION_ID NUMBER
Yes
APPLICATION_NAME VARCHAR2 (240) Yes
EVENT_CLASS VARCHAR2 (30)
EVENT_CLASS_CODE VARCHAR2 (30)
ANALYTICAL_CRITERION VARCHAR2 (80) Yes
ANALYTICAL_CRITERION_CODE VARCHAR2 (100) Yes
AMB_CONTEXT_CODE VARCHAR2 (30) Yes
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 (1) Yes
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT MAPPING_HEADER_ID
,      CHART_OF_ACCOUNTS_ID
,      APPLICATION_ID
,      APPLICATION_NAME
,      EVENT_CLASS
,      EVENT_CLASS_CODE
,      ANALYTICAL_CRITERION
,      ANALYTICAL_CRITERION_CODE
,      AMB_CONTEXT_CODE
,      ANALYTICAL_CRITERION_TYPE_CODE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V;

Dependencies

[top of page]

APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V references the following:

SchemaAPPS
SynonymFND_APPLICATION_TL
SynonymJA_CN_CFS_ITEM_MAPPING_HDRS
SynonymXLA_ANALYTICAL_DTLS_B
SynonymXLA_ANALYTICAL_DTLS_TL
SynonymXLA_ANALYTICAL_HDRS_TL
SynonymXLA_ANALYTICAL_SOURCES

APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V is not referenced by any database object