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

VIEW: APPS.AMS_IMP_LIST_HEADERS_ALL_V

Object Details
Object Name: AMS_IMP_LIST_HEADERS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_IMP_LIST_HEADERS_ALL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
IMPORT_LIST_HEADER_ID NUMBER
Yes Unique Identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
VIEW_APPLICATION_ID NUMBER
Yes The ID of the application from which the record is viewable.
NAME VARCHAR2 (120)
Name of the import.
VERSION VARCHAR2 (10) Yes Version of the import.
IMPORT_TYPE VARCHAR2 (30) Yes Used to indicate the type of imported data.
OWNER_USER_ID NUMBER (15) Yes The user ID of the owner of the import.
OWNER VARCHAR2 (360)
The name of the owner of the import.
LIST_SOURCE_TYPE_ID NUMBER

FK to reference list column mapping.
USER_STATUS_ID NUMBER
Yes The internal ID of the status of the import.
STATUS_CODE VARCHAR2 (30) Yes The de-normalized status of the import.
STATUS_DATE DATE
Yes The date the last status change occurred.
SOURCE_SYSTEM VARCHAR2 (4000)
The source from which the import data originated.
VENDOR_ID NUMBER

The source vendor for the import data.
PIN_ID NUMBER (15)
Not implemented.
ORG_ID NUMBER (32)
Operating Unit Identifier
SCHEDULED_TIME DATE

Date and time to schedule data imports.
LOADED_NO_OF_ROWS NUMBER (15)
The number of rows imported into the interface table.
LOADED_DATE DATE

The date on which the import load completes successfully.
ROWS_TO_SKIP NUMBER (15)
Number of rows in the data file to skip during the import.
PROCESSED_ROWS NUMBER (15)
Number of rows which were processed by the post-import processing procedure.
HEADINGS_FLAG VARCHAR2 (1)
Flag which indicates whether the data file contains a field heading.
DEDUPE_FLAG VARCHAR2 (1)
Column to indicate whether dedupe needs to be done on the imported data.
PROCESS_IMMED_FLAG VARCHAR2 (1)
Column to indicate whether to immediately call the API to process the imported data.
EXPIRY_DATE DATE

The date on which the imported date expires from the system.
PURGE_DATE DATE

The date on which the imported data was purged from the application.
DESCRIPTION VARCHAR2 (4000)
The description of the import.
KEYWORDS VARCHAR2 (4000)
Keywords on which the import information can be searched.
TRANSACTIONAL_COST NUMBER (15)
Value used to hold the internal monetary amount based on an internal currency code.
TRANSACTIONAL_CURRENCY_CODE VARCHAR2 (15)
Code used to indicate the internally used currency code.
FUNCTIONAL_COST NUMBER (15)
Published cost having the values determined by the user-defined currency code.
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
User-defined currency code.
DATA_FILENAME VARCHAR2 (1000)
Column to save the name and path of the file which was last used to import the external data and size should be 500.
TERMINATED_BY VARCHAR2 (30)
Character used as the field delimiter.
ENCLOSED_BY VARCHAR2 (30)
Character optionally used in conjunction with the delimiter to separate the fields, particularly for those data items which contain the delimiter character.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfiled structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment.
Query Text

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


SELECT IMPORT_LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      VIEW_APPLICATION_ID
,      NAME
,      VERSION
,      IMPORT_TYPE
,      OWNER_USER_ID
,      OWNER
,      LIST_SOURCE_TYPE_ID
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      SOURCE_SYSTEM
,      VENDOR_ID
,      PIN_ID
,      ORG_ID
,      SCHEDULED_TIME
,      LOADED_NO_OF_ROWS
,      LOADED_DATE
,      ROWS_TO_SKIP
,      PROCESSED_ROWS
,      HEADINGS_FLAG
,      DEDUPE_FLAG
,      PROCESS_IMMED_FLAG
,      EXPIRY_DATE
,      PURGE_DATE
,      DESCRIPTION
,      KEYWORDS
,      TRANSACTIONAL_COST
,      TRANSACTIONAL_CURRENCY_CODE
,      FUNCTIONAL_COST
,      FUNCTIONAL_CURRENCY_CODE
,      DATA_FILENAME
,      TERMINATED_BY
,      ENCLOSED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.AMS_IMP_LIST_HEADERS_ALL_V;

Dependencies

[top of page]

APPS.AMS_IMP_LIST_HEADERS_ALL_V references the following:

SchemaAPPS
SynonymAMS_IMP_LIST_HEADERS_ALL
ViewAMS_JTF_RS_EMP_V

APPS.AMS_IMP_LIST_HEADERS_ALL_V is not referenced by any database object