[Home] [Help] [Dependency Information]
Object Name: | AP_EXPENSE_REPORT_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | SQLAP.AP_EXPENSE_REPORT_HISTORY_V |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
APPS.AP_EXPENSE_REPORT_HISTORY_V is not referenced by any database object
|
|
|