DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AP_EXPENSE_REPORT_HISTORY_V

Object Details
Object Name: AP_EXPENSE_REPORT_HISTORY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_EXPENSE_REPORT_HISTORY_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


Expense Report History in Oracle Internet Expenses is based on this view


[View Source]

Columns
Name Datatype Length Mandatory Comments
AMT_DUE_CCARD_COMPANY NUMBER

Amount due credit card company
AMT_DUE_EMPLOYEE NUMBER

Amount due employee
DESCRIPTION VARCHAR2 (240)
Purpose of expense report
INVOICE_AMOUNT VARCHAR2 (4000)
Invoice amount of expense report
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Currency code of invoice
WITHHELD_AMOUNT_CURRENCY_CODE VARCHAR2 (56)
Currency code of withheld amount
INVOICE_DATE DATE

Date of invoice
INVOICE_ID NUMBER

Invoice id
INVOICE_NUM VARCHAR2 (50)
Invoice number
DUE_DATE DATE

Due date of expense report
GROSS_AMOUNT_QUERY NUMBER

Unformatted gross amount of expense report
GROSS_AMOUNT VARCHAR2 (4000)
Gross amount of expense report formatted as a string
AMOUNT_REMAINING VARCHAR2 (4000)
Amount remaining
EMPLOYEE_ID NUMBER (10)
Employee id
REPORT_PRIMARY_KEY NUMBER

Primary key of expense report
REPORT_HEADER_ID NUMBER

Report Header id of expense report
DOCUMENT_TYPE VARCHAR2 (14)
Document type
FULL_NAME VARCHAR2 (240)
Full name of employee
STATUS VARCHAR2 (80)
Status of expense report
SOURCE VARCHAR2 (25)
Source of expense report
VIEW_PAYABLES_FIELD VARCHAR2 (23)
Region Item For Switcher Bean
REPORT_NUMBER_FIELD VARCHAR2 (20)
Region Item For Expense Lines Switcher Bean
EXPENSE_LINES_FIELD VARCHAR2 (24)
Region Item For Expense Lines Switcher Bean
DUPLICATE_FIELD VARCHAR2 (22)
Region Item For Duplicate Icon Switcher Bean
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AMT_DUE_CCARD_COMPANY
,      AMT_DUE_EMPLOYEE
,      DESCRIPTION
,      INVOICE_AMOUNT
,      INVOICE_CURRENCY_CODE
,      WITHHELD_AMOUNT_CURRENCY_CODE
,      INVOICE_DATE
,      INVOICE_ID
,      INVOICE_NUM
,      DUE_DATE
,      GROSS_AMOUNT_QUERY
,      GROSS_AMOUNT
,      AMOUNT_REMAINING
,      EMPLOYEE_ID
,      REPORT_PRIMARY_KEY
,      REPORT_HEADER_ID
,      DOCUMENT_TYPE
,      FULL_NAME
,      STATUS
,      SOURCE
,      VIEW_PAYABLES_FIELD
,      REPORT_NUMBER_FIELD
,      EXPENSE_LINES_FIELD
,      DUPLICATE_FIELD
FROM APPS.AP_EXPENSE_REPORT_HISTORY_V;

Dependencies

[top of page]

APPS.AP_EXPENSE_REPORT_HISTORY_V references the following:

SchemaAPPS
SynonymAP_EXPENSE_REPORT_HEADERS
SynonymAP_INVOICES
ViewAP_LOOKUP_CODES
SynonymAP_PAYMENT_SCHEDULES
PL/SQL PackageAP_WEB_DB_HR_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_OA_ACTIVE_PKG - show dependent code
PL/SQL PackageFND_CURRENCY_CACHE - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageICX_AP_INVOICES_PKG - show dependent code
ViewPER_PEOPLE_X
ViewPO_VENDORS

APPS.AP_EXPENSE_REPORT_HISTORY_V is not referenced by any database object