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

VIEW: APPS.APBV_EXPENSE_REPORT_PARAMS

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

View Type

A Business Intelligence System view


Based on AP_EXPENSE_REPORT_PARAMS_ALL, this view contains expense type data.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Yes Expense item identifier
EXPENSE_REPORT_ID NUMBER
Yes Expense report template identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROMPT VARCHAR2 (40) Yes Name of expense item
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Name of line type
VAT_CODE VARCHAR2 (30)
Tax code
FLEX_CCID NUMBER

No longer used
FLEX_DESCRIPTION VARCHAR2 (240)
Description of Accounting Flexfield segments
FLEX_CONCACTENATED VARCHAR2 (240)
Skeletal flexfield overlaid the employee''s default Accounting Flexfield to create the line Accounting Flexfield
SUMMARY_FLAG VARCHAR2 (1)
Not currently used
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID NUMBER (15)
Organization identifier
WEB_ENABLED_FLAG VARCHAR2 (1)
Indicates whether template is enabled for Oracle Self-Service Expenses.
WEB_FRIENDLY_PROMPT VARCHAR2 (80)
Name of expense item as it appears in Oracle Self-Service Expenses.
WEB_IMAGE_FILENAME VARCHAR2 (240)
No longer used.
JUSTIFICATION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether an employee is required to enter a justification for this expense type.
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether your payables department requires that a receipt be sent to them for all expenses of this expense type.
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Indicates that the amounts users enter for this expense item include tax.
WEB_SEQUENCE NUMBER

No longer used.
CALCULATE_AMOUNT_FLAG VARCHAR2 (1)
Indicates whether Oracle Self-Service Expenses displays the calculate amount button.
REQUIRE_RECEIPT_AMOUNT NUMBER

Indicates the amount above which your accounts payable department requires a receipt for this expense type.
PA_EXPENDITURE_TYPE VARCHAR2 (30)
Projects expenditure type mapped to the Payables expense item
CARD_EXP_TYPE_LOOKUP_CODE VARCHAR2 (30)
Credit card expense type that is mapped to this record
ITEMIZATION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether or not end user is required to itemize the corresponding expense type.
ITEMIZATION_ALL_FLAG VARCHAR2 (1)
Indicates whether or not the itemization page will include all expense types.
COMPANY_POLICY_ID NUMBER (15)
Identifies the policy schedule associated with the expense item.
CATEGORY_CODE VARCHAR2 (30)
Expense category associated with the expense item.
END_DATE DATE

End Date for the expense type. Once this date plus any grace period has passed, then the associated expense type is no longer available in the Expense Reports, unless the associated expense report is still in workflow.
EXPENSE_TYPE_CODE VARCHAR2 (30)
The seeded expense type used for personal and rounding expenses
DATA_CAPTURE_RULE_ID NUMBER (15)
Rule Id associating the data capture rule to the current expense type row.
Query Text

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


SELECT PARAMETER_ID
,      EXPENSE_REPORT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PROMPT
,      LINE_TYPE_LOOKUP_CODE
,      VAT_CODE
,      FLEX_CCID
,      FLEX_DESCRIPTION
,      FLEX_CONCACTENATED
,      SUMMARY_FLAG
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
,      WEB_ENABLED_FLAG
,      WEB_FRIENDLY_PROMPT
,      WEB_IMAGE_FILENAME
,      JUSTIFICATION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      AMOUNT_INCLUDES_TAX_FLAG
,      WEB_SEQUENCE
,      CALCULATE_AMOUNT_FLAG
,      REQUIRE_RECEIPT_AMOUNT
,      PA_EXPENDITURE_TYPE
,      CARD_EXP_TYPE_LOOKUP_CODE
,      ITEMIZATION_REQUIRED_FLAG
,      ITEMIZATION_ALL_FLAG
,      COMPANY_POLICY_ID
,      CATEGORY_CODE
,      END_DATE
,      EXPENSE_TYPE_CODE
,      DATA_CAPTURE_RULE_ID
FROM APPS.APBV_EXPENSE_REPORT_PARAMS;

Dependencies

[top of page]

APPS.APBV_EXPENSE_REPORT_PARAMS references the following:

SchemaAPPS
SynonymAP_EXPENSE_REPORT_PARAMS_ALL

APPS.APBV_EXPENSE_REPORT_PARAMS is not referenced by any database object