VIEW: APPS.AP_PBATCH_SET_LINES_V

Source

View Text - Preformatted

SELECT apsl.rowid ROW_ID, apsl.batch_set_id, apsl.batch_set_line_id, apsl.batch_name, apsl.include_in_set, apsl.printer, apsl.check_stock_id, apsl.bank_account_id, apsl.vendor_pay_group, apsl.hi_payment_priority, apsl.low_payment_priority, apsl.max_payment_amount, apsl.min_check_amount, apsl.max_outlay, apsl.pay_only_when_due_flag, apsl.exchange_rate_type, GDCT.USER_CONVERSION_TYPE USER_RATE_TYPE, apsl.document_order_lookup_code, apsl.payment_currency_code, apsl.audit_required_flag, apsl.interval, apsl.volume_serial_number, apsl.zero_amounts_allowed, apsl.zero_invoices_allowed, apsl.future_pmts_allowed, apsl.last_update_date, apsl.last_update_login, apsl.last_updated_by, apsl.created_by, apsl.creation_date, apsl.attribute_category, apsl.attribute1, apsl.attribute2, apsl.attribute3, apsl.attribute4, apsl.attribute5, apsl.attribute6, apsl.attribute7, apsl.attribute8, apsl.attribute9, apsl.attribute10, apsl.attribute11, apsl.attribute12, apsl.attribute13, apsl.attribute14, apsl.attribute15, apsl.org_id, apsl.transfer_priority, aba.bank_account_name, acs.name document_name, acs.future_dated_payments_flag, apsl.inactive_date, apsl.vendor_id, pv.vendor_name FROM AP_PBATCH_SET_LINES apsl, AP_BANK_ACCOUNTS aba, AP_CHECK_STOCKS acs, GL_DAILY_CONVERSION_TYPES GDCT, PO_VENDORS PV WHERE apsl.bank_account_id = aba.bank_account_id AND apsl.check_stock_id = acs.check_stock_id AND apsl.EXCHANGE_RATE_TYPE = GDCT.CONVERSION_TYPE (+) and apsl.vendor_id = pv.vendor_id (+)

View Text - HTML Formatted

SELECT APSL.ROWID ROW_ID
, APSL.BATCH_SET_ID
, APSL.BATCH_SET_LINE_ID
, APSL.BATCH_NAME
, APSL.INCLUDE_IN_SET
, APSL.PRINTER
, APSL.CHECK_STOCK_ID
, APSL.BANK_ACCOUNT_ID
, APSL.VENDOR_PAY_GROUP
, APSL.HI_PAYMENT_PRIORITY
, APSL.LOW_PAYMENT_PRIORITY
, APSL.MAX_PAYMENT_AMOUNT
, APSL.MIN_CHECK_AMOUNT
, APSL.MAX_OUTLAY
, APSL.PAY_ONLY_WHEN_DUE_FLAG
, APSL.EXCHANGE_RATE_TYPE
, GDCT.USER_CONVERSION_TYPE USER_RATE_TYPE
, APSL.DOCUMENT_ORDER_LOOKUP_CODE
, APSL.PAYMENT_CURRENCY_CODE
, APSL.AUDIT_REQUIRED_FLAG
, APSL.INTERVAL
, APSL.VOLUME_SERIAL_NUMBER
, APSL.ZERO_AMOUNTS_ALLOWED
, APSL.ZERO_INVOICES_ALLOWED
, APSL.FUTURE_PMTS_ALLOWED
, APSL.LAST_UPDATE_DATE
, APSL.LAST_UPDATE_LOGIN
, APSL.LAST_UPDATED_BY
, APSL.CREATED_BY
, APSL.CREATION_DATE
, APSL.ATTRIBUTE_CATEGORY
, APSL.ATTRIBUTE1
, APSL.ATTRIBUTE2
, APSL.ATTRIBUTE3
, APSL.ATTRIBUTE4
, APSL.ATTRIBUTE5
, APSL.ATTRIBUTE6
, APSL.ATTRIBUTE7
, APSL.ATTRIBUTE8
, APSL.ATTRIBUTE9
, APSL.ATTRIBUTE10
, APSL.ATTRIBUTE11
, APSL.ATTRIBUTE12
, APSL.ATTRIBUTE13
, APSL.ATTRIBUTE14
, APSL.ATTRIBUTE15
, APSL.ORG_ID
, APSL.TRANSFER_PRIORITY
, ABA.BANK_ACCOUNT_NAME
, ACS.NAME DOCUMENT_NAME
, ACS.FUTURE_DATED_PAYMENTS_FLAG
, APSL.INACTIVE_DATE
, APSL.VENDOR_ID
, PV.VENDOR_NAME
FROM AP_PBATCH_SET_LINES APSL
, AP_BANK_ACCOUNTS ABA
, AP_CHECK_STOCKS ACS
, GL_DAILY_CONVERSION_TYPES GDCT
, PO_VENDORS PV
WHERE APSL.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND APSL.CHECK_STOCK_ID = ACS.CHECK_STOCK_ID
AND APSL.EXCHANGE_RATE_TYPE = GDCT.CONVERSION_TYPE (+)
AND APSL.VENDOR_ID = PV.VENDOR_ID (+)