View: APBV_EXPENSE_REPORT_HEADERS

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.APBV_EXPENSE_REPORT_HEADERS

View Text

SELECT AERHA.REPORT_HEADER_ID
, AERHA.EMPLOYEE_ID
, AERHA.WEEK_END_DATE
, AERHA.CREATION_DATE
, AERHA.CREATED_BY
, AERHA.LAST_UPDATE_DATE
, AERHA.LAST_UPDATED_BY
, AERHA.VOUCHNO
, AERHA.TOTAL
, AERHA.VENDOR_ID
, AERHA.VENDOR_SITE_ID
, AERHA.EXPENSE_CHECK_ADDRESS_FLAG
, AERHA.REFERENCE_1
, AERHA.REFERENCE_2
, AERHA.INVOICE_NUM
, AERHA.EXPENSE_REPORT_ID
, AERHA.ACCTS_PAY_CODE_COMBINATION_ID
, AERHA.SET_OF_BOOKS_ID
, AERHA.SOURCE
, AERHA.PURGEABLE_FLAG
, AERHA.ACCOUNTING_DATE
, AERHA.MAXIMUM_AMOUNT_TO_APPLY
, AERHA.ADVANCE_INVOICE_TO_APPLY
, AERHA.APPLY_ADVANCES_DEFAULT
, AERHA.EMPLOYEE_CCID
, AERHA.DESCRIPTION
, AERHA.REJECT_CODE
, AERHA.HOLD_LOOKUP_CODE
, '_DF:SQLAP:AP_EXPENSE_REPORT_HEADERS:AERHA'
, AERHA.DEFAULT_CURRENCY_CODE
, AERHA.DEFAULT_EXCHANGE_RATE_TYPE
, AERHA.DEFAULT_EXCHANGE_RATE
, AERHA.DEFAULT_EXCHANGE_DATE
, AERHA.VOUCHER_NUM
, AERHA.USSGL_TRANSACTION_CODE
, AERHA.USSGL_TRX_CODE_CONTEXT
, AERHA.DOC_CATEGORY_CODE
, AERHA.AWT_GROUP_ID
, AERHA.ORG_ID
, AERHA.WORKFLOW_APPROVED_FLAG
, AERHA.FLEX_CONCATENATED
, AERHA.OVERRIDE_APPROVER_ID
, AERHA.PAYMENT_CROSS_RATE_TYPE
, AERHA.PAYMENT_CROSS_RATE_DATE
, AERHA.PAYMENT_CROSS_RATE
, AERHA.PAYMENT_CURRENCY_CODE
, AERHA.CORE_WF_STATUS_FLAG
, AERHA.PREPAY_APPLY_FLAG
, AERHA.PREPAY_NUM
, AERHA.PREPAY_DIST_NUM
, AERHA.PREPAY_APPLY_AMOUNT
, AERHA.PREPAY_GL_DATE
, AERHA.BOTHPAY_PARENT_ID
, AERHA.SHORTPAY_PARENT_ID
, AERHA.PAID_ON_BEHALF_EMPLOYEE_ID
, AERHA.OVERRIDE_APPROVER_NAME
, AERHA.AMT_DUE_CCARD_COMPANY
, AERHA.AMT_DUE_EMPLOYEE
, AERHA.DEFAULT_RECEIPT_CURRENCY_CODE
, AERHA.MULTIPLE_CURRENCIES_FLAG
, NVL(AERHA.EXPENSE_STATUS_CODE
, AP_WEB_OA_ACTIVE_PKG.GETREPORTSTATUSCODE(AERHA.SOURCE
, AERHA.WORKFLOW_APPROVED_FLAG
, AERHA.REPORT_HEADER_ID
, 'Y'
, 'N'))
, AERHA.EXPENSE_LAST_STATUS_DATE
, AERHA.EXPENSE_CURRENT_APPROVER_ID
, AERHA.REPORT_FILING_NUMBER
, AERHA.RECEIPTS_RECEIVED_DATE
, AERHA.AUDIT_CODE
, AERHA.REPORT_SUBMITTED_DATE
, AERHA.LAST_AUDITED_BY
, AERHA.RETURN_REASON_CODE
, AERHA.RETURN_INSTRUCTION
, AERHA.RECEIPTS_STATUS
, AERHA.HOLDING_REPORT_HEADER_ID
, AERHA.REQUEST_ID
FROM AP_EXPENSE_REPORT_HEADERS_ALL AERHA
WHERE '_SEC:AERHA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns