VIEW: APPS.AP_BATCHES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')