View: AP_BATCHES_V

Product:	AP - Payables
Description:	(Release 10SC only)
Implementation/DBA Data:	APPS.AP_BATCHES_V

View Text

SELECT AB.ROWID ROW_ID
, AB.ATTRIBUTE1 ATTRIBUTE1
, AB.ATTRIBUTE2 ATTRIBUTE2
, AB.ATTRIBUTE3 ATTRIBUTE3
, AB.ATTRIBUTE4 ATTRIBUTE4
, AB.ATTRIBUTE5 ATTRIBUTE5
, AB.ATTRIBUTE6 ATTRIBUTE6
, AB.ATTRIBUTE7 ATTRIBUTE7
, AB.ATTRIBUTE8 ATTRIBUTE8
, AB.ATTRIBUTE9 ATTRIBUTE9
, AB.ATTRIBUTE10 ATTRIBUTE10
, AB.ATTRIBUTE11 ATTRIBUTE11
, AB.ATTRIBUTE12 ATTRIBUTE12
, AB.ATTRIBUTE13 ATTRIBUTE13
, AB.ATTRIBUTE14 ATTRIBUTE14
, AB.ATTRIBUTE15 ATTRIBUTE15
, AB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AB.BATCH_CODE_COMBINATION_ID BATCH_CODE_COMBINATION_ID
, AB.BATCH_DATE BATCH_DATE
, AB.BATCH_ID BATCH_ID
, AB.BATCH_NAME BATCH_NAME
, AB.CONTROL_INVOICE_COUNT CONTROL_INVOICE_COUNT
, AB.CONTROL_INVOICE_TOTAL CONTROL_INVOICE_TOTAL
, AB.CREATED_BY CREATED_BY
, AB.CREATION_DATE CREATION_DATE
, AB.DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, AB.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE
, AB.HOLD_REASON HOLD_REASON
, AB.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AB.INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE_LOOKUP_CODE
, AB.LAST_UPDATED_BY LAST_UPDATED_BY
, AB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AB.ORG_ID ORG_ID
, AB.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, AB.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, AB.TERMS_ID TERMS_ID
, AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT( AB.BATCH_ID) ACTUAL_INVOICE_COUNT
, AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT( AB.BATCH_ID) ACTUAL_INVOICE_TOTAL
, AT.NAME PAYMENT_TERMS_NAME
, FDSC.NAME DOCUMENT_CATEGORY
, ALC2.DISPLAYED_FIELD HOLD_NAME
, AB.GL_DATE GL_DATE
, AB.PAYMENT_PRIORITY PAYMENT_PRIORITY
FROM AP_BATCHES_ALL AB
, AP_TERMS AT
, FND_DOC_SEQUENCE_CATEGORIES FDSC
, AP_LOOKUP_CODES ALC2
WHERE AT.TERM_ID (+) = AB.TERMS_ID
AND FDSC.APPLICATION_ID (+) = 200
AND FDSC.CODE (+)= AB.DOC_CATEGORY_CODE
AND ALC2.LOOKUP_TYPE (+) = 'HOLD CODE'
AND ALC2.LOOKUP_CODE (+) = AB.HOLD_LOOKUP_CODE
AND (MO_GLOBAL.CHECK_ACCESS(AB.ORG_ID) = 'Y' OR AB.ORG_ID IS NULL)
AND NOT EXISTS (SELECT AI.INVOICE_ID
FROM AP_INVOICES_ALL AI
WHERE AI.BATCH_ID = AB.BATCH_ID
AND MO_GLOBAL.CHECK_ACCESS(AI.ORG_ID) = 'N')

Columns