[Home] [Help] [Dependency Information]
Object Name: | AMS_IMP_LIST_HEADERS_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_IMP_LIST_HEADERS_ALL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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. |
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;
APPS.AMS_IMP_LIST_HEADERS_ALL_V is not referenced by any database object
|
|
|