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: POS.POS_IMP_BATCH_SUMMARY

Object Details

Object Name:	POS_IMP_BATCH_SUMMARY
Object Type:	TABLE
Owner:	POS
FND Design Data:	POS.POS_IMP_BATCH_SUMMARY
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POS_IMP_BATCH_SUMMARY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory
BATCH_ID	NUMBER		Yes
BATCH_NAME	VARCHAR2	(255)	Yes
DESCRIPTION	VARCHAR2	(2000)
LOAD_TYPE	VARCHAR2	(30)
BATCH_DEDUP_FLAG	VARCHAR2	(1)
ORIGINAL_SYSTEM	VARCHAR2	(30)	Yes
BATCH_DEDUP_MATCH_RULE_ID	NUMBER
ERROR_LIMIT	NUMBER
BATCH_DEDUP_STATUS	VARCHAR2	(30)
ADDR_VAL_STATUS	VARCHAR2	(30)
IMPORT_STATUS	VARCHAR2	(30)
BATCH_STATUS	VARCHAR2	(30)
BATCH_DEDUP_REQ_ID	NUMBER
ADDR_VAL_REQ_ID	NUMBER
PURGE_DATE	DATE
PURGED_BY_USER_ID	NUMBER
TOTAL_BATCH_RECORDS	NUMBER
SUPPLIERS_IN_BATCH	NUMBER
SITES_IN_BATCH	NUMBER
CONTACTS_IN_BATCH	NUMBER
BUSS_CLASS_IN_BATCH	NUMBER
PROD_SERV_IN_BATCH	NUMBER
BANK_DETLS_IN_BATCH	NUMBER
TAX_DTLS_IN_BATCH	NUMBER
REMOVED_BY_USER	NUMBER
TOTAL_RECORDS_FOR_IMPORT	NUMBER
TOTAL_RECORDS_IMPORTED	NUMBER
TOTAL_INSERTS	NUMBER
TOTAL_UPDATES	NUMBER
TOTAL_MERGE_REQUESTS	NUMBER
TOTAL_AUTO_MERGED	NUMBER
SUPPLIERS_INSERTED	NUMBER
SITES_INSERTED	NUMBER
CONTACTS_INSERTED	NUMBER
BUSS_CLASS_INSERTED	NUMBER
PROD_SERV_INSERTED	NUMBER
BANK_DETLS_INSERTED	NUMBER
TAX_DTLS_INSERTED	NUMBER
SUPPLIERS_UPDATED	NUMBER
SITES_UPDATED	NUMBER
CONTACTS_UPDATED	NUMBER
BUSS_CLASS_UPDATED	NUMBER
PROD_SERV_UPDATED	NUMBER
BANK_DETLS_UPDATED	NUMBER
TAX_DTLS_UPDATED	NUMBER
SUPPLIERS_MERGE_REQUESTS	NUMBER
SITES_MERGE_REQUESTS	NUMBER
CONTACTS_MERGE_REQUESTS	NUMBER
SUPPLIERS_AUTO_MERGED	NUMBER
SUPPLIERS_IMPORTED	NUMBER
SITES_IMPORTED	NUMBER
CONTACTS_IMPORTED	NUMBER
BUSS_CLASS_IMPORTED	NUMBER
PROD_SERV_IMPORTED	NUMBER
BANK_DETLS_IMPORTED	NUMBER
TAX_DTLS_IMPORTED	NUMBER
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
EST_NO_OF_RECORDS	NUMBER
MAIN_CONC_STATUS	VARCHAR2	(30)
IMPORT_REQ_ID	NUMBER

Query Text

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


SELECT BATCH_ID
,      BATCH_NAME
,      DESCRIPTION
,      LOAD_TYPE
,      BATCH_DEDUP_FLAG
,      ORIGINAL_SYSTEM
,      BATCH_DEDUP_MATCH_RULE_ID
,      ERROR_LIMIT
,      BATCH_DEDUP_STATUS
,      ADDR_VAL_STATUS
,      IMPORT_STATUS
,      BATCH_STATUS
,      BATCH_DEDUP_REQ_ID
,      ADDR_VAL_REQ_ID
,      PURGE_DATE
,      PURGED_BY_USER_ID
,      TOTAL_BATCH_RECORDS
,      SUPPLIERS_IN_BATCH
,      SITES_IN_BATCH
,      CONTACTS_IN_BATCH
,      BUSS_CLASS_IN_BATCH
,      PROD_SERV_IN_BATCH
,      BANK_DETLS_IN_BATCH
,      TAX_DTLS_IN_BATCH
,      REMOVED_BY_USER
,      TOTAL_RECORDS_FOR_IMPORT
,      TOTAL_RECORDS_IMPORTED
,      TOTAL_INSERTS
,      TOTAL_UPDATES
,      TOTAL_MERGE_REQUESTS
,      TOTAL_AUTO_MERGED
,      SUPPLIERS_INSERTED
,      SITES_INSERTED
,      CONTACTS_INSERTED
,      BUSS_CLASS_INSERTED
,      PROD_SERV_INSERTED
,      BANK_DETLS_INSERTED
,      TAX_DTLS_INSERTED
,      SUPPLIERS_UPDATED
,      SITES_UPDATED
,      CONTACTS_UPDATED
,      BUSS_CLASS_UPDATED
,      PROD_SERV_UPDATED
,      BANK_DETLS_UPDATED
,      TAX_DTLS_UPDATED
,      SUPPLIERS_MERGE_REQUESTS
,      SITES_MERGE_REQUESTS
,      CONTACTS_MERGE_REQUESTS
,      SUPPLIERS_AUTO_MERGED
,      SUPPLIERS_IMPORTED
,      SITES_IMPORTED
,      CONTACTS_IMPORTED
,      BUSS_CLASS_IMPORTED
,      PROD_SERV_IMPORTED
,      BANK_DETLS_IMPORTED
,      TAX_DTLS_IMPORTED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EST_NO_OF_RECORDS
,      MAIN_CONC_STATUS
,      IMPORT_REQ_ID
FROM POS.POS_IMP_BATCH_SUMMARY;

Dependencies

[top of page]

POS.POS_IMP_BATCH_SUMMARY does not reference any database object

POS.POS_IMP_BATCH_SUMMARY is referenced by following:

POS: POS_IMP_BATCH_SUMMARY#