VIEW: AP.AP_PBATCH_SET_LINES_ALL#

Source

View Text - Preformatted

select BATCH_NAME BATCH_NAME, BATCH_SET_LINE_ID BATCH_SET_LINE_ID, BATCH_SET_ID BATCH_SET_ID, INCLUDE_IN_SET INCLUDE_IN_SET, PRINTER PRINTER, CHECK_STOCK_ID CHECK_STOCK_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, VENDOR_PAY_GROUP VENDOR_PAY_GROUP, HI_PAYMENT_PRIORITY HI_PAYMENT_PRIORITY, LOW_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY, MAX_PAYMENT_AMOUNT MAX_PAYMENT_AMOUNT, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT, MAX_OUTLAY MAX_OUTLAY, PAY_ONLY_WHEN_DUE_FLAG PAY_ONLY_WHEN_DUE_FLAG, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, DOCUMENT_ORDER_LOOKUP_CODE DOCUMENT_ORDER_LOOKUP_CODE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, AUDIT_REQUIRED_FLAG AUDIT_REQUIRED_FLAG, INTERVAL INTERVAL, VOLUME_SERIAL_NUMBER VOLUME_SERIAL_NUMBER, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED, ZERO_INVOICES_ALLOWED ZERO_INVOICES_ALLOWED, FUTURE_PMTS_ALLOWED FUTURE_PMTS_ALLOWED, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, INACTIVE_DATE INACTIVE_DATE, TRANSFER_PRIORITY TRANSFER_PRIORITY, VENDOR_ID VENDOR_ID, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID, DAYS_BETWEEN_CHECK_CYCLES DAYS_BETWEEN_CHECK_CYCLES from "AP"."AP_PBATCH_SET_LINES_ALL"

View Text - HTML Formatted

SELECT BATCH_NAME BATCH_NAME
, BATCH_SET_LINE_ID BATCH_SET_LINE_ID
, BATCH_SET_ID BATCH_SET_ID
, INCLUDE_IN_SET INCLUDE_IN_SET
, PRINTER PRINTER
, CHECK_STOCK_ID CHECK_STOCK_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, VENDOR_PAY_GROUP VENDOR_PAY_GROUP
, HI_PAYMENT_PRIORITY HI_PAYMENT_PRIORITY
, LOW_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY
, MAX_PAYMENT_AMOUNT MAX_PAYMENT_AMOUNT
, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT
, MAX_OUTLAY MAX_OUTLAY
, PAY_ONLY_WHEN_DUE_FLAG PAY_ONLY_WHEN_DUE_FLAG
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, DOCUMENT_ORDER_LOOKUP_CODE DOCUMENT_ORDER_LOOKUP_CODE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, AUDIT_REQUIRED_FLAG AUDIT_REQUIRED_FLAG
, INTERVAL INTERVAL
, VOLUME_SERIAL_NUMBER VOLUME_SERIAL_NUMBER
, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED
, ZERO_INVOICES_ALLOWED ZERO_INVOICES_ALLOWED
, FUTURE_PMTS_ALLOWED FUTURE_PMTS_ALLOWED
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, INACTIVE_DATE INACTIVE_DATE
, TRANSFER_PRIORITY TRANSFER_PRIORITY
, VENDOR_ID VENDOR_ID
, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID
, DAYS_BETWEEN_CHECK_CYCLES DAYS_BETWEEN_CHECK_CYCLES
FROM "AP"."AP_PBATCH_SET_LINES_ALL"