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

VIEW: APPS.AMS_IMP_LIST_HEADERS_VL

Object Details
Object Name: AMS_IMP_LIST_HEADERS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_IMP_LIST_HEADERS_VL
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)
Version number
VIEW_APPLICATION_ID NUMBER
Yes View application identifier
NAME VARCHAR2 (240) Yes List header name
VERSION VARCHAR2 (10) Yes Version
IMPORT_TYPE VARCHAR2 (30) Yes List import type
OWNER_USER_ID NUMBER (15) Yes Owner user identifier
CUSTOM_SETUP_ID NUMBER

Custom setup identifier
COUNTRY NUMBER

Country
LIST_SOURCE_TYPE_ID NUMBER

List source type identifier.
STATUS_CODE VARCHAR2 (30) Yes Status code
STATUS_DATE DATE
Yes Status date
USER_STATUS_ID NUMBER
Yes User status identifier
SOURCE_SYSTEM VARCHAR2 (4000)
Source system
VENDOR_ID NUMBER

Vendor identifier
PIN_ID NUMBER (15)
Pin identifier
ORG_ID NUMBER (32)
Organization identifier
SCHEDULED_TIME DATE

Scheduled time
LOADED_NO_OF_ROWS NUMBER (15)
Loaded number of rows
LOADED_DATE DATE

Lode date
ROWS_TO_SKIP NUMBER (15)
Rows to skip
PROCESSED_ROWS NUMBER (15)
Number of processed rows
HEADINGS_FLAG VARCHAR2 (1)
Heading flag
EXPIRY_DATE DATE

Expiry date
PURGE_DATE DATE

Purge date
DESCRIPTION VARCHAR2 (4000)
Description
KEYWORDS VARCHAR2 (4000)
Keywords
TRANSACTIONAL_COST NUMBER (15)
Transactional cost
TRANSACTIONAL_CURRENCY_CODE VARCHAR2 (15)
Currency code
FUNCTIONAL_COST NUMBER (15)
Functional cost
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
TERMINATED_BY VARCHAR2 (30)
Column terminated by
ENCLOSED_BY VARCHAR2 (30)
Column enclosed by
DATA_FILENAME VARCHAR2 (1000)
Data File name
PROCESS_IMMED_FLAG VARCHAR2 (1)
Column not used
DEDUPE_FLAG VARCHAR2 (1)
Deduplication flag to check duplicates.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfiled structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfiled segment.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfiled segment.
SECURITY_GROUP_ID NUMBER

Security group identifier
USAGE NUMBER

Usage
RENTED_LIST_FLAG VARCHAR2 (1)
Rented or purchased flag
SERVER_FLAG VARCHAR2 (1)
Client or server flag
LOG_FILE_NAME VARCHAR2 (60)
Log file name
NUMBER_OF_FAILED_RECORDS NUMBER

Number of failed records.
NUMBER_OF_DUPLICATE_RECORDS NUMBER

Number of duplicate records
B2B_FLAG VARCHAR2 (1)
B2B or B2C flag
NUMBER_OF_RECORDS VARCHAR2 (240)
Number of records
ENABLE_WORD_REPLACEMENT_FLAG VARCHAR2 (1)
Enable word replacement for deduplication.
DATA_FILE_NAME VARCHAR2 (1000)
Data file name for client side list import.
BATCH_ID NUMBER

EXECUTE_MODE VARCHAR2 (1)
VALIDATE_FILE VARCHAR2 (1)
RECORD_UPDATE_FLAG VARCHAR2 (1)
Flag to update the record.
ERROR_THRESHOLD NUMBER

Error threshold for import.
SERVER_NAME VARCHAR2 (256)
Server name for ftp import.
USER_NAME VARCHAR2 (256)
User name for ftp import.
PASSWORD VARCHAR2 (256)
Password for ftp import.
UPLOAD_FLAG VARCHAR2 (1)
Upload flag
PARENT_IMP_HEADER_ID NUMBER

Parent header id for import.
RECURRING_IMP_NAME VARCHAR2 (120)
Recurring import name.
CANCEL_FLAG VARCHAR2 (1)
Cancel flag.
CANCEL_DATE DATE

Cancel date
REPEAT_TIME VARCHAR2 (60)
Repeat time for import.
REPEAT_INTERVAL NUMBER

Repeat interval of import.
REPEAT_UNIT VARCHAR2 (30)
Repeat unit for import.
REPEAT_END_TIME VARCHAR2 (60)
Repeat end time for import.
REPEAT_START_TIME VARCHAR2 (60)
Repeat start time for import.
REPEAT_MODE VARCHAR2 (60)
Repeat mode for import.
CHARSET VARCHAR2 (30)
This column stores the character set.
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
,      CUSTOM_SETUP_ID
,      COUNTRY
,      LIST_SOURCE_TYPE_ID
,      STATUS_CODE
,      STATUS_DATE
,      USER_STATUS_ID
,      SOURCE_SYSTEM
,      VENDOR_ID
,      PIN_ID
,      ORG_ID
,      SCHEDULED_TIME
,      LOADED_NO_OF_ROWS
,      LOADED_DATE
,      ROWS_TO_SKIP
,      PROCESSED_ROWS
,      HEADINGS_FLAG
,      EXPIRY_DATE
,      PURGE_DATE
,      DESCRIPTION
,      KEYWORDS
,      TRANSACTIONAL_COST
,      TRANSACTIONAL_CURRENCY_CODE
,      FUNCTIONAL_COST
,      FUNCTIONAL_CURRENCY_CODE
,      TERMINATED_BY
,      ENCLOSED_BY
,      DATA_FILENAME
,      PROCESS_IMMED_FLAG
,      DEDUPE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      USAGE
,      RENTED_LIST_FLAG
,      SERVER_FLAG
,      LOG_FILE_NAME
,      NUMBER_OF_FAILED_RECORDS
,      NUMBER_OF_DUPLICATE_RECORDS
,      B2B_FLAG
,      NUMBER_OF_RECORDS
,      ENABLE_WORD_REPLACEMENT_FLAG
,      DATA_FILE_NAME
,      BATCH_ID
,      EXECUTE_MODE
,      VALIDATE_FILE
,      RECORD_UPDATE_FLAG
,      ERROR_THRESHOLD
,      SERVER_NAME
,      USER_NAME
,      PASSWORD
,      UPLOAD_FLAG
,      PARENT_IMP_HEADER_ID
,      RECURRING_IMP_NAME
,      CANCEL_FLAG
,      CANCEL_DATE
,      REPEAT_TIME
,      REPEAT_INTERVAL
,      REPEAT_UNIT
,      REPEAT_END_TIME
,      REPEAT_START_TIME
,      REPEAT_MODE
,      CHARSET
FROM APPS.AMS_IMP_LIST_HEADERS_VL;

Dependencies

[top of page]

APPS.AMS_IMP_LIST_HEADERS_VL references the following:

SchemaAPPS
SynonymAMS_IMP_LIST_HEADERS_ALL
SynonymAMS_IMP_LIST_HEADERS_ALL_TL
APPS.AMS_IMP_LIST_HEADERS_VL is referenced by following:

SchemaAPPS
Package BodyAMS_IMPORT_LIST_PVT - show dependent code
Package BodyAMS_LISTGENERATION_PKG - show dependent code