Skip to content FND Design Data [Home] [Help]

View: AP_ACTIVE_EXPENSE_REPORTS_V

Product: AP - Payables
Description: Active Expense Reports in Oracle Internet Expenses is based on this view
Implementation/DBA Data: Not implemented in this database
View Text

SELECT P.FULL_NAME
, P.PERSON_ID
, AERH.DESCRIPTION
, AERH.TOTAL TOTAL
, TO_CHAR((AERH.TOTAL)
, FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE
, 30)) ||' '||AERH.DEFAULT_CURRENCY_CODE FORMATTED_TOTAL
, AERH.DEFAULT_CURRENCY_CODE
, AERH.WEEK_END_DATE
, AERH.INVOICE_NUM
, AERH.REPORT_HEADER_ID
, ALC.DISPLAYED_FIELD
, DECODE (AERH.WORKFLOW_APPROVED_FLAG
, 'R'
, 'DUPLICATEIMAGEDISABLED'
, 'T'
, 'DUPLICATEIMAGEDISABLED'
, 'DUPLICATEIMAGEENABLED')
, AERH.LAST_UPDATE_DATE
FROM PER_PEOPLE_X P
, AP_EXPENSE_REPORT_HEADERS AERH
, AP_LOOKUP_CODES ALC
WHERE P.PERSON_ID = AERH.EMPLOYEE_ID
AND AERH.VOUCHNO+0 =0
AND AERH.SOURCE = 'NONVALIDATEDWEBEXPENSE'
AND AERH.WORKFLOW_APPROVED_FLAG IN ('S'
, 'R'
, 'T'
, 'W')
AND ALC.LOOKUP_TYPE = 'EXPENSE REPORT STATUS'
AND ALC.LOOKUP_CODE =DECODE(AERH.WORKFLOW_APPROVED_FLAG
, 'S'
, 'SAVED'
, 'R'
, 'REJECTED'
, 'T'
, 'RETURNED'
, 'W'
, 'WITHDRAWN')

Columns

Name
FULL_NAME
PERSON_ID
PURPOSE
TOTAL
FORMATTED_TOTAL
CURRENCY
REPORT_DATE
INVOICE_NUM
REPORT_ID
STATUS
DUPLICATE_FIELD
LAST_UPDATE_DATE