[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 |