VIEW: AR.HZ_IMP_BATCH_SUMMARY#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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