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: AR.HZ_IMP_BATCH_SUMMARY#

Object Details

Object Name:	HZ_IMP_BATCH_SUMMARY#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BATCH_ID	NUMBER	(15)	Yes
BATCH_NAME	VARCHAR2	(255)	Yes
DESCRIPTION	VARCHAR2	(1996)
EST_NO_OF_RECORDS	NUMBER
ORIGINAL_SYSTEM	VARCHAR2	(30)	Yes
LOAD_TYPE	VARCHAR2	(30)
BATCH_DEDUP_FLAG	VARCHAR2	(1)
BATCH_DEDUP_MATCH_RULE_ID	NUMBER	(15)
BD_ACTION_ON_PARTIES	VARCHAR2	(30)
BD_ACTION_ON_ADDRESSES	VARCHAR2	(30)
BD_ACTION_ON_CONTACTS	VARCHAR2	(30)
BD_ACTION_ON_CONTACT_POINTS	VARCHAR2	(30)
ADDR_VAL_FLAG	VARCHAR2	(1)
REGISTRY_DEDUP_FLAG	VARCHAR2	(1)
REGISTRY_DEDUP_MATCH_RULE_ID	NUMBER	(15)
REMOVE_DUPS_FLAG	VARCHAR2	(1)
ERROR_LIMIT	NUMBER
VALIDATE_FLEXFIELD_FLAG	VARCHAR2	(1)
WHAT_IF_FLAG	VARCHAR2	(1)
RD_ACTION_NEW_PARTIES	VARCHAR2	(30)
RD_ACTION_EXISTING_PARTIES	VARCHAR2	(30)
RD_ACTION_DUP_PARTIES	VARCHAR2	(30)
RD_ACTION_POT_DUP_PARTIES	VARCHAR2	(30)
RD_ACTION_NEW_ADDRS	VARCHAR2	(30)
RD_ACTION_EXISTING_ADDRS	VARCHAR2	(30)
RD_ACTION_POT_DUP_ADDRS	VARCHAR2	(30)
RD_ACTION_NEW_CONTACTS	VARCHAR2	(30)
RD_ACTION_EXISTING_CONTACTS	VARCHAR2	(30)
RD_ACTION_POT_DUP_CONTACTS	VARCHAR2	(30)
RD_ACTION_NEW_CPTS	VARCHAR2	(30)
RD_ACTION_EXISTING_CPTS	VARCHAR2	(30)
RD_ACTION_POT_DUP_CPTS	VARCHAR2	(30)
RD_ACTION_NEW_SUPENTS	VARCHAR2	(30)
RD_ACTION_EXISTING_SUPENTS	VARCHAR2	(30)
RD_ACTION_NEW_FINENTS	VARCHAR2	(30)
RD_ACTION_EXISTING_FINENTS	VARCHAR2	(30)
BATCH_DEDUP_STATUS	VARCHAR2	(30)
ADDR_VAL_STATUS	VARCHAR2	(30)
IMPORT_STATUS	VARCHAR2	(30)
CSV_STATUS	VARCHAR2	(30)
BATCH_STATUS	VARCHAR2	(30)
MAIN_CONC_STATUS	VARCHAR2	(30)
BATCH_DEDUP_REQ_ID	NUMBER	(15)
ADDR_VAL_REQ_ID	NUMBER	(15)
IMPORT_REQ_ID	NUMBER	(15)
CSV_LOAD_REQ_ID	NUMBER	(15)
MAIN_CONC_REQ_ID	NUMBER	(15)
CSV_LOAD_ID	NUMBER	(15)
PURGE_DATE	DATE
PURGED_BY_USER_ID	NUMBER	(15)
TOTAL_BATCH_RECORDS	NUMBER
PARTIES_IN_BATCH	NUMBER
ADDRESSES_IN_BATCH	NUMBER
ADDRESSUSES_IN_BATCH	NUMBER
CONTACTPOINTS_IN_BATCH	NUMBER
CONTACTS_IN_BATCH	NUMBER
CONTACTROLES_IN_BATCH	NUMBER
CODEASSIGNS_IN_BATCH	NUMBER
RELATIONSHIPS_IN_BATCH	NUMBER
CREDITRATINGS_IN_BATCH	NUMBER
FINREPORTS_IN_BATCH	NUMBER
FINNUMBERS_IN_BATCH	NUMBER
REMOVED_BY_USER	NUMBER
TOTAL_RECORDS_FOR_IMPORT	NUMBER
DUP_PARTIES_IN_BATCH	NUMBER
DUP_ADDRESSES_IN_BATCH	NUMBER
DUP_CONTACTPOINTS_IN_BATCH	NUMBER
DUP_CONTACTS_IN_BATCH	NUMBER
PARTY_DUP_SETS_IN_BATCH	NUMBER
ADDRESS_DUP_SETS_IN_BATCH	NUMBER
CONTACTPOINT_DUP_SETS_IN_BATCH	NUMBER
CONTACT_DUP_SETS_IN_BATCH	NUMBER
NEW_UNIQUE_PARTIES	NUMBER
POTENTIAL_DUP_PARTIES	NUMBER
DUP_PARTIES	NUMBER
EXISTING_PARTIES	NUMBER
NEW_UNIQUE_ADDRESSES	NUMBER
POTENTIAL_DUP_ADDRESSES	NUMBER
EXISTING_ADDRESSES	NUMBER
NEW_UNIQUE_CONTACTPOINTS	NUMBER
POTENTIAL_DUP_CONTACTPOINTS	NUMBER
EXISTING_CONTACTPOINTS	NUMBER
NEW_UNIQUE_CONTACTS	NUMBER
POTENTIAL_DUP_CONTACTS	NUMBER
EXISTING_CONTACTS	NUMBER
NEW_UNIQUE_ADDRESSUSES	NUMBER
EXISTING_ADDRESSUSES	NUMBER
NEW_UNIQUE_CONTACTROLES	NUMBER
EXISTING_CONTACTROLES	NUMBER
NEW_UNIQUE_CODEASSIGNS	NUMBER
EXISTING_CODEASSIGNS	NUMBER
NEW_UNIQUE_RELATIONSHIPS	NUMBER
EXISTING_RELATIONSHIPS	NUMBER
NEW_UNIQUE_FINREPORTS	NUMBER
EXISTING_FINREPORTS	NUMBER
NEW_UNIQUE_FINNUMBERS	NUMBER
EXISTING_FINNUMBERS	NUMBER
NEW_UNIQUE_CREDITRATINGS	NUMBER
EXISTING_CREDITRATINGS	NUMBER
TOTAL_RECORDS_IMPORTED	NUMBER
TOTAL_ERRORS	NUMBER
PARTIES_FULLY_IMPORTED	NUMBER
PARTIES_PARTIALLY_IMPORTED	NUMBER
TOTAL_PERSONS_IMPORTED	NUMBER
TOTAL_ORGANIZATIONS_IMPORTE	NUMBER
TOTAL_INSERTS	NUMBER
TOTAL_UPDATES	NUMBER
TOTAL_MERGE_REQUESTS	NUMBER
TOTAL_AUTO_MERGED	NUMBER
PARTIES_INSERTED	NUMBER
ADDRESSES_INSERTED	NUMBER
ADDRESSUSES_INSERTED	NUMBER
CONTACTPOINTS_INSERTED	NUMBER
CONTACTS_INSERTED	NUMBER
CONTACTROLES_INSERTED	NUMBER
CODEASSIGNS_INSERTED	NUMBER
RELATIONSHIPS_INSERTED	NUMBER
CREDITRATINGS_INSERTED	NUMBER
FINREPORTS_INSERTED	NUMBER
FINNUMBERS_INSERTED	NUMBER
PARTIES_UPDATED	NUMBER
ADDRESSES_UPDATED	NUMBER
ADDRESSUSES_UPDATED	NUMBER
CONTACTPOINTS_UPDATED	NUMBER
CONTACTS_UPDATED	NUMBER
CONTACTROLES_UPDATED	NUMBER
CODEASSIGNS_UPDATED	NUMBER
RELATIONSHIPS_UPDATED	NUMBER
CREDITRATINGS_UPDATED	NUMBER
FINREPORTS_UPDATED	NUMBER
FINNUMBERS_UPDATED	NUMBER
PARTY_MERGE_REQUESTS	NUMBER
ADDRESS_MERGE_REQUESTS	NUMBER
CONTACTPOINT_MERGE_REQUESTS	NUMBER
CONTACT_MERGE_REQUESTS	NUMBER
PARTIES_AUTO_MERGED	NUMBER
PARTIES_IMPORTED	NUMBER
ADDRESSES_IMPORTED	NUMBER
ADDRESSUSES_IMPORTED	NUMBER
CONTACTPOINTS_IMPORTED	NUMBER
CONTACTS_IMPORTED	NUMBER
CONTACTROLES_IMPORTED	NUMBER
CODEASSIGNS_IMPORTED	NUMBER
RELATIONSHIPS_IMPORTED	NUMBER
CREDITRATINGS_IMPORTED	NUMBER
FINREPORTS_IMPORTED	NUMBER
FINNUMBERS_IMPORTED	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
NUM_PARTIES_PURCHASED	NUMBER
AUTOMERGE_FLAG	VARCHAR2	(1)

Query Text

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


SELECT BATCH_ID
,      BATCH_NAME
,      DESCRIPTION
,      EST_NO_OF_RECORDS
,      ORIGINAL_SYSTEM
,      LOAD_TYPE
,      BATCH_DEDUP_FLAG
,      BATCH_DEDUP_MATCH_RULE_ID
,      BD_ACTION_ON_PARTIES
,      BD_ACTION_ON_ADDRESSES
,      BD_ACTION_ON_CONTACTS
,      BD_ACTION_ON_CONTACT_POINTS
,      ADDR_VAL_FLAG
,      REGISTRY_DEDUP_FLAG
,      REGISTRY_DEDUP_MATCH_RULE_ID
,      REMOVE_DUPS_FLAG
,      ERROR_LIMIT
,      VALIDATE_FLEXFIELD_FLAG
,      WHAT_IF_FLAG
,      RD_ACTION_NEW_PARTIES
,      RD_ACTION_EXISTING_PARTIES
,      RD_ACTION_DUP_PARTIES
,      RD_ACTION_POT_DUP_PARTIES
,      RD_ACTION_NEW_ADDRS
,      RD_ACTION_EXISTING_ADDRS
,      RD_ACTION_POT_DUP_ADDRS
,      RD_ACTION_NEW_CONTACTS
,      RD_ACTION_EXISTING_CONTACTS
,      RD_ACTION_POT_DUP_CONTACTS
,      RD_ACTION_NEW_CPTS
,      RD_ACTION_EXISTING_CPTS
,      RD_ACTION_POT_DUP_CPTS
,      RD_ACTION_NEW_SUPENTS
,      RD_ACTION_EXISTING_SUPENTS
,      RD_ACTION_NEW_FINENTS
,      RD_ACTION_EXISTING_FINENTS
,      BATCH_DEDUP_STATUS
,      ADDR_VAL_STATUS
,      IMPORT_STATUS
,      CSV_STATUS
,      BATCH_STATUS
,      MAIN_CONC_STATUS
,      BATCH_DEDUP_REQ_ID
,      ADDR_VAL_REQ_ID
,      IMPORT_REQ_ID
,      CSV_LOAD_REQ_ID
,      MAIN_CONC_REQ_ID
,      CSV_LOAD_ID
,      PURGE_DATE
,      PURGED_BY_USER_ID
,      TOTAL_BATCH_RECORDS
,      PARTIES_IN_BATCH
,      ADDRESSES_IN_BATCH
,      ADDRESSUSES_IN_BATCH
,      CONTACTPOINTS_IN_BATCH
,      CONTACTS_IN_BATCH
,      CONTACTROLES_IN_BATCH
,      CODEASSIGNS_IN_BATCH
,      RELATIONSHIPS_IN_BATCH
,      CREDITRATINGS_IN_BATCH
,      FINREPORTS_IN_BATCH
,      FINNUMBERS_IN_BATCH
,      REMOVED_BY_USER
,      TOTAL_RECORDS_FOR_IMPORT
,      DUP_PARTIES_IN_BATCH
,      DUP_ADDRESSES_IN_BATCH
,      DUP_CONTACTPOINTS_IN_BATCH
,      DUP_CONTACTS_IN_BATCH
,      PARTY_DUP_SETS_IN_BATCH
,      ADDRESS_DUP_SETS_IN_BATCH
,      CONTACTPOINT_DUP_SETS_IN_BATCH
,      CONTACT_DUP_SETS_IN_BATCH
,      NEW_UNIQUE_PARTIES
,      POTENTIAL_DUP_PARTIES
,      DUP_PARTIES
,      EXISTING_PARTIES
,      NEW_UNIQUE_ADDRESSES
,      POTENTIAL_DUP_ADDRESSES
,      EXISTING_ADDRESSES
,      NEW_UNIQUE_CONTACTPOINTS
,      POTENTIAL_DUP_CONTACTPOINTS
,      EXISTING_CONTACTPOINTS
,      NEW_UNIQUE_CONTACTS
,      POTENTIAL_DUP_CONTACTS
,      EXISTING_CONTACTS
,      NEW_UNIQUE_ADDRESSUSES
,      EXISTING_ADDRESSUSES
,      NEW_UNIQUE_CONTACTROLES
,      EXISTING_CONTACTROLES
,      NEW_UNIQUE_CODEASSIGNS
,      EXISTING_CODEASSIGNS
,      NEW_UNIQUE_RELATIONSHIPS
,      EXISTING_RELATIONSHIPS
,      NEW_UNIQUE_FINREPORTS
,      EXISTING_FINREPORTS
,      NEW_UNIQUE_FINNUMBERS
,      EXISTING_FINNUMBERS
,      NEW_UNIQUE_CREDITRATINGS
,      EXISTING_CREDITRATINGS
,      TOTAL_RECORDS_IMPORTED
,      TOTAL_ERRORS
,      PARTIES_FULLY_IMPORTED
,      PARTIES_PARTIALLY_IMPORTED
,      TOTAL_PERSONS_IMPORTED
,      TOTAL_ORGANIZATIONS_IMPORTE
,      TOTAL_INSERTS
,      TOTAL_UPDATES
,      TOTAL_MERGE_REQUESTS
,      TOTAL_AUTO_MERGED
,      PARTIES_INSERTED
,      ADDRESSES_INSERTED
,      ADDRESSUSES_INSERTED
,      CONTACTPOINTS_INSERTED
,      CONTACTS_INSERTED
,      CONTACTROLES_INSERTED
,      CODEASSIGNS_INSERTED
,      RELATIONSHIPS_INSERTED
,      CREDITRATINGS_INSERTED
,      FINREPORTS_INSERTED
,      FINNUMBERS_INSERTED
,      PARTIES_UPDATED
,      ADDRESSES_UPDATED
,      ADDRESSUSES_UPDATED
,      CONTACTPOINTS_UPDATED
,      CONTACTS_UPDATED
,      CONTACTROLES_UPDATED
,      CODEASSIGNS_UPDATED
,      RELATIONSHIPS_UPDATED
,      CREDITRATINGS_UPDATED
,      FINREPORTS_UPDATED
,      FINNUMBERS_UPDATED
,      PARTY_MERGE_REQUESTS
,      ADDRESS_MERGE_REQUESTS
,      CONTACTPOINT_MERGE_REQUESTS
,      CONTACT_MERGE_REQUESTS
,      PARTIES_AUTO_MERGED
,      PARTIES_IMPORTED
,      ADDRESSES_IMPORTED
,      ADDRESSUSES_IMPORTED
,      CONTACTPOINTS_IMPORTED
,      CONTACTS_IMPORTED
,      CONTACTROLES_IMPORTED
,      CODEASSIGNS_IMPORTED
,      RELATIONSHIPS_IMPORTED
,      CREDITRATINGS_IMPORTED
,      FINREPORTS_IMPORTED
,      FINNUMBERS_IMPORTED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      NUM_PARTIES_PURCHASED
,      AUTOMERGE_FLAG
FROM AR.HZ_IMP_BATCH_SUMMARY#;

Dependencies

[top of page]

AR.HZ_IMP_BATCH_SUMMARY# references the following:

AR: HZ_IMP_BATCH_SUMMARY

AR.HZ_IMP_BATCH_SUMMARY# is referenced by following:

APPS: HZ_IMP_BATCH_SUMMARY