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


VIEW: AMS.AMS_IMP_DEFAULT_MAPPING#

Object Details
Object Name: AMS_IMP_DEFAULT_MAPPING#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEFAULT_MAPPING_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
IMPORT_TYPE VARCHAR2 (30)
LIST_SOURCE_TYPE_ID NUMBER
Yes
FILE_TYPE VARCHAR2 (30)
EXP_TEMPLATE_ID NUMBER

EXPORT_TYPE VARCHAR2 (30)
Query Text

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


SELECT DEFAULT_MAPPING_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      IMPORT_TYPE
,      LIST_SOURCE_TYPE_ID
,      FILE_TYPE
,      EXP_TEMPLATE_ID
,      EXPORT_TYPE
FROM AMS.AMS_IMP_DEFAULT_MAPPING#;

Dependencies

[top of page]

AMS.AMS_IMP_DEFAULT_MAPPING# references the following:

SchemaAMS
TableAMS_IMP_DEFAULT_MAPPING
AMS.AMS_IMP_DEFAULT_MAPPING# is referenced by following:

SchemaAPPS
SynonymAMS_IMP_DEFAULT_MAPPING