VIEW: POS.POS_IMP_BATCH_SUMMARY#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, BATCH_NAME BATCH_NAME, DESCRIPTION DESCRIPTION, LOAD_TYPE LOAD_TYPE, BATCH_DEDUP_FLAG BATCH_DEDUP_FLAG, ORIGINAL_SYSTEM ORIGINAL_SYSTEM, BATCH_DEDUP_MATCH_RULE_ID BATCH_DEDUP_MATCH_RULE_ID, ERROR_LIMIT ERROR_LIMIT, BATCH_DEDUP_STATUS BATCH_DEDUP_STATUS, ADDR_VAL_STATUS ADDR_VAL_STATUS, IMPORT_STATUS IMPORT_STATUS, BATCH_STATUS BATCH_STATUS, BATCH_DEDUP_REQ_ID BATCH_DEDUP_REQ_ID, ADDR_VAL_REQ_ID ADDR_VAL_REQ_ID, PURGE_DATE PURGE_DATE, PURGED_BY_USER_ID PURGED_BY_USER_ID, TOTAL_BATCH_RECORDS TOTAL_BATCH_RECORDS, SUPPLIERS_IN_BATCH SUPPLIERS_IN_BATCH, SITES_IN_BATCH SITES_IN_BATCH, CONTACTS_IN_BATCH CONTACTS_IN_BATCH, BUSS_CLASS_IN_BATCH BUSS_CLASS_IN_BATCH, PROD_SERV_IN_BATCH PROD_SERV_IN_BATCH, BANK_DETLS_IN_BATCH BANK_DETLS_IN_BATCH, TAX_DTLS_IN_BATCH TAX_DTLS_IN_BATCH, REMOVED_BY_USER REMOVED_BY_USER, TOTAL_RECORDS_FOR_IMPORT TOTAL_RECORDS_FOR_IMPORT, TOTAL_RECORDS_IMPORTED TOTAL_RECORDS_IMPORTED, TOTAL_INSERTS TOTAL_INSERTS, TOTAL_UPDATES TOTAL_UPDATES, TOTAL_MERGE_REQUESTS TOTAL_MERGE_REQUESTS, TOTAL_AUTO_MERGED TOTAL_AUTO_MERGED, SUPPLIERS_INSERTED SUPPLIERS_INSERTED, SITES_INSERTED SITES_INSERTED, CONTACTS_INSERTED CONTACTS_INSERTED, BUSS_CLASS_INSERTED BUSS_CLASS_INSERTED, PROD_SERV_INSERTED PROD_SERV_INSERTED, BANK_DETLS_INSERTED BANK_DETLS_INSERTED, TAX_DTLS_INSERTED TAX_DTLS_INSERTED, SUPPLIERS_UPDATED SUPPLIERS_UPDATED, SITES_UPDATED SITES_UPDATED, CONTACTS_UPDATED CONTACTS_UPDATED, BUSS_CLASS_UPDATED BUSS_CLASS_UPDATED, PROD_SERV_UPDATED PROD_SERV_UPDATED, BANK_DETLS_UPDATED BANK_DETLS_UPDATED, TAX_DTLS_UPDATED TAX_DTLS_UPDATED, SUPPLIERS_MERGE_REQUESTS SUPPLIERS_MERGE_REQUESTS, SITES_MERGE_REQUESTS SITES_MERGE_REQUESTS, CONTACTS_MERGE_REQUESTS CONTACTS_MERGE_REQUESTS, SUPPLIERS_AUTO_MERGED SUPPLIERS_AUTO_MERGED, SUPPLIERS_IMPORTED SUPPLIERS_IMPORTED, SITES_IMPORTED SITES_IMPORTED, CONTACTS_IMPORTED CONTACTS_IMPORTED, BUSS_CLASS_IMPORTED BUSS_CLASS_IMPORTED, PROD_SERV_IMPORTED PROD_SERV_IMPORTED, BANK_DETLS_IMPORTED BANK_DETLS_IMPORTED, TAX_DTLS_IMPORTED TAX_DTLS_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, EST_NO_OF_RECORDS EST_NO_OF_RECORDS, MAIN_CONC_STATUS MAIN_CONC_STATUS, IMPORT_REQ_ID IMPORT_REQ_ID from "POS"."POS_IMP_BATCH_SUMMARY"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_NAME BATCH_NAME
, DESCRIPTION DESCRIPTION
, LOAD_TYPE LOAD_TYPE
, BATCH_DEDUP_FLAG BATCH_DEDUP_FLAG
, ORIGINAL_SYSTEM ORIGINAL_SYSTEM
, BATCH_DEDUP_MATCH_RULE_ID BATCH_DEDUP_MATCH_RULE_ID
, ERROR_LIMIT ERROR_LIMIT
, BATCH_DEDUP_STATUS BATCH_DEDUP_STATUS
, ADDR_VAL_STATUS ADDR_VAL_STATUS
, IMPORT_STATUS IMPORT_STATUS
, BATCH_STATUS BATCH_STATUS
, BATCH_DEDUP_REQ_ID BATCH_DEDUP_REQ_ID
, ADDR_VAL_REQ_ID ADDR_VAL_REQ_ID
, PURGE_DATE PURGE_DATE
, PURGED_BY_USER_ID PURGED_BY_USER_ID
, TOTAL_BATCH_RECORDS TOTAL_BATCH_RECORDS
, SUPPLIERS_IN_BATCH SUPPLIERS_IN_BATCH
, SITES_IN_BATCH SITES_IN_BATCH
, CONTACTS_IN_BATCH CONTACTS_IN_BATCH
, BUSS_CLASS_IN_BATCH BUSS_CLASS_IN_BATCH
, PROD_SERV_IN_BATCH PROD_SERV_IN_BATCH
, BANK_DETLS_IN_BATCH BANK_DETLS_IN_BATCH
, TAX_DTLS_IN_BATCH TAX_DTLS_IN_BATCH
, REMOVED_BY_USER REMOVED_BY_USER
, TOTAL_RECORDS_FOR_IMPORT TOTAL_RECORDS_FOR_IMPORT
, TOTAL_RECORDS_IMPORTED TOTAL_RECORDS_IMPORTED
, TOTAL_INSERTS TOTAL_INSERTS
, TOTAL_UPDATES TOTAL_UPDATES
, TOTAL_MERGE_REQUESTS TOTAL_MERGE_REQUESTS
, TOTAL_AUTO_MERGED TOTAL_AUTO_MERGED
, SUPPLIERS_INSERTED SUPPLIERS_INSERTED
, SITES_INSERTED SITES_INSERTED
, CONTACTS_INSERTED CONTACTS_INSERTED
, BUSS_CLASS_INSERTED BUSS_CLASS_INSERTED
, PROD_SERV_INSERTED PROD_SERV_INSERTED
, BANK_DETLS_INSERTED BANK_DETLS_INSERTED
, TAX_DTLS_INSERTED TAX_DTLS_INSERTED
, SUPPLIERS_UPDATED SUPPLIERS_UPDATED
, SITES_UPDATED SITES_UPDATED
, CONTACTS_UPDATED CONTACTS_UPDATED
, BUSS_CLASS_UPDATED BUSS_CLASS_UPDATED
, PROD_SERV_UPDATED PROD_SERV_UPDATED
, BANK_DETLS_UPDATED BANK_DETLS_UPDATED
, TAX_DTLS_UPDATED TAX_DTLS_UPDATED
, SUPPLIERS_MERGE_REQUESTS SUPPLIERS_MERGE_REQUESTS
, SITES_MERGE_REQUESTS SITES_MERGE_REQUESTS
, CONTACTS_MERGE_REQUESTS CONTACTS_MERGE_REQUESTS
, SUPPLIERS_AUTO_MERGED SUPPLIERS_AUTO_MERGED
, SUPPLIERS_IMPORTED SUPPLIERS_IMPORTED
, SITES_IMPORTED SITES_IMPORTED
, CONTACTS_IMPORTED CONTACTS_IMPORTED
, BUSS_CLASS_IMPORTED BUSS_CLASS_IMPORTED
, PROD_SERV_IMPORTED PROD_SERV_IMPORTED
, BANK_DETLS_IMPORTED BANK_DETLS_IMPORTED
, TAX_DTLS_IMPORTED TAX_DTLS_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
, EST_NO_OF_RECORDS EST_NO_OF_RECORDS
, MAIN_CONC_STATUS MAIN_CONC_STATUS
, IMPORT_REQ_ID IMPORT_REQ_ID
FROM "POS"."POS_IMP_BATCH_SUMMARY"