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]

TABLE: IMC.IMC_CSV_LOAD_DETAILS

Object Details

Object Name:	IMC_CSV_LOAD_DETAILS
Object Type:	TABLE
Owner:	IMC
Subobject Name:
Status:	VALID

This table stores detail information about the load e.g.load name, description, file location, file structure, number of records processed.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LOAD_ID	NUMBER	(15)	Yes	Number that uniquely identifies the Load Batch
LOAD_NAME	VARCHAR2	(100)	Yes	Name of the load batch provided by user
LOAD_DESC	VARCHAR2	(255)		Description of the load batch provided by user
SOURCE_FILE_LOCATION	VARCHAR2	(255)		Location of the source file in user�s desktop
SOURCE_SYSTEM	VARCHAR2	(30)		Source system used to load the data in TCA
HEADER_EXISTS_FLAG	VARCHAR2	(1)		Indicates whether a column header information exists in the file
COLUMN_DELIMITER	VARCHAR2	(1)		The character representing the delimiter
FIELD_ENCLOSED_BY	VARCHAR2	(1)		The character used to enclose the column values
DATE_FORMAT	VARCHAR2	(15)		Date format used for this load
PARTY_TYPE	VARCHAR2	(50)		Type of the party loaded by this load
ADDRESS_FLAG	VARCHAR2	(1)		Indicates whether address information was provided
CONTACT_POINTS_FLAG	VARCHAR2	(1)		Indicates whether contact point information was provided
CLASSIFICATION_FLAG	VARCHAR2	(1)		Indicates whether classification information was provided
BATCH_ID	NUMBER	(15)		The BATCH_ID in HZ_IMP_BATCH_SUMMARY Table that this CSV load maps to
CSV_REQ_ID	NUMBER	(15)		Request ID for the CSV load process
NO_OF_FILE_LOAD_RECS	NUMBER	(9)		Number of records in the load
NO_OF_PARTIES_FOR_EXPT	NUMBER	(9)		Number of parties for export
NO_OF_PARTIES_WITH_ERR	NUMBER	(9)		Number of parties with error
NO_OF_ATTRIBS_WITH_ERR	NUMBER	(9)		Number of attributes with error
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT LOAD_ID
,      LOAD_NAME
,      LOAD_DESC
,      SOURCE_FILE_LOCATION
,      SOURCE_SYSTEM
,      HEADER_EXISTS_FLAG
,      COLUMN_DELIMITER
,      FIELD_ENCLOSED_BY
,      DATE_FORMAT
,      PARTY_TYPE
,      ADDRESS_FLAG
,      CONTACT_POINTS_FLAG
,      CLASSIFICATION_FLAG
,      BATCH_ID
,      CSV_REQ_ID
,      NO_OF_FILE_LOAD_RECS
,      NO_OF_PARTIES_FOR_EXPT
,      NO_OF_PARTIES_WITH_ERR
,      NO_OF_ATTRIBS_WITH_ERR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IMC.IMC_CSV_LOAD_DETAILS;

Dependencies

[top of page]

IMC.IMC_CSV_LOAD_DETAILS does not reference any database object

IMC.IMC_CSV_LOAD_DETAILS is referenced by following:

IMC: IMC_CSV_LOAD_DETAILS#