Product: | AP - Payables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AP_PBATCH_SET_LINES_V |
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 (+)