[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | APBV_EXPENSE_REPORT_PARAMS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  SQLAP.APBV_EXPENSE_REPORT_PARAMS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Based on AP_EXPENSE_REPORT_PARAMS_ALL, this view contains expense type data.
| 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. |
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;
APPS
AP_EXPENSE_REPORT_PARAMS_ALL
APPS.APBV_EXPENSE_REPORT_PARAMS is not referenced by any database object
|
|
|
|