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 Comments
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:

SchemaAR
TableHZ_IMP_BATCH_SUMMARY
AR.HZ_IMP_BATCH_SUMMARY# is referenced by following:

SchemaAPPS
SynonymHZ_IMP_BATCH_SUMMARY