VIEW: APPS.APBV_EXPENSE_REPORT_HEADERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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