VIEW: CN.CN_PROCESS_BATCHES_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, PROCESS_BATCH_ID PROCESS_BATCH_ID, SRP_PERIOD_ID SRP_PERIOD_ID, PERIOD_ID PERIOD_ID, SALESREP_ID SALESREP_ID, LOGICAL_BATCH_ID LOGICAL_BATCH_ID, PHYSICAL_BATCH_ID PHYSICAL_BATCH_ID, STATUS_CODE STATUS_CODE, SALES_LINES_TOTAL SALES_LINES_TOTAL, PROCESS_BATCH_NAME PROCESS_BATCH_NAME, CREATED_BY_USER_ID CREATED_BY_USER_ID, CREATED_ON_DATE CREATED_ON_DATE, TRX_BATCH_ID TRX_BATCH_ID, PROCESS_BATCH_TYPE PROCESS_BATCH_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, START_DATE START_DATE, END_DATE END_DATE, QUOTA_ID QUOTA_ID, END_PERIOD_ID END_PERIOD_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, COMMISSION_HEADERS_COUNT COMMISSION_HEADERS_COUNT from "CN"."CN_PROCESS_BATCHES_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, PROCESS_BATCH_ID PROCESS_BATCH_ID
, SRP_PERIOD_ID SRP_PERIOD_ID
, PERIOD_ID PERIOD_ID
, SALESREP_ID SALESREP_ID
, LOGICAL_BATCH_ID LOGICAL_BATCH_ID
, PHYSICAL_BATCH_ID PHYSICAL_BATCH_ID
, STATUS_CODE STATUS_CODE
, SALES_LINES_TOTAL SALES_LINES_TOTAL
, PROCESS_BATCH_NAME PROCESS_BATCH_NAME
, CREATED_BY_USER_ID CREATED_BY_USER_ID
, CREATED_ON_DATE CREATED_ON_DATE
, TRX_BATCH_ID TRX_BATCH_ID
, PROCESS_BATCH_TYPE PROCESS_BATCH_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, START_DATE START_DATE
, END_DATE END_DATE
, QUOTA_ID QUOTA_ID
, END_PERIOD_ID END_PERIOD_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, COMMISSION_HEADERS_COUNT COMMISSION_HEADERS_COUNT
FROM "CN"."CN_PROCESS_BATCHES_ALL"