eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	AMS.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:

APPS: AMS_IMP_LIST_HEADERS_ALL; AMS_IMP_LIST_HEADERS_ALL_TL

APPS.AMS_IMP_LIST_HEADERS_VL is referenced by following:

APPS: AMS_IMPORT_LIST_PVT - show dependent code; AMS_LISTGENERATION_PKG - show dependent code