eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_EXPENSE_REPORT_PARAMS_ALL

Object Details

Object Name:	AP_EXPENSE_REPORT_PARAMS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_EXPENSE_REPORT_PARAMS_ALL
Subobject Name:
Status:	VALID

AP_EXPENSE_REPORT_PARAMS_ALL stores accounting distribution
information about expense report types you define. You
need one row for each line you want in the template for
an expense report template that you use to enter employee
expense reports.
.
This table corresponds to the lines region of the Expense Report Templates window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_EXPENSE_REPORT_PARAMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARAMETER_ID ZD_EDITION_NAME
AP_EXPENSE_REPORT_PARAMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENSE_REPORT_ID PROMPT ORG_ID ZD_EDITION_NAME

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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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.
DUPLICATES_ALLOWED	NUMBER			Holds the number of duplicates allowed for this expense type
CARD_REQUIRE_RECEIPT_AMOUNT	NUMBER			Card Require Receipt Amount
NEG_RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		Neg Receipt Required Flag
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      LAST_UPDATE_LOGIN
,      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
,      DUPLICATES_ALLOWED
,      CARD_REQUIRE_RECEIPT_AMOUNT
,      NEG_RECEIPT_REQUIRED_FLAG
,      ZD_EDITION_NAME
FROM AP.AP_EXPENSE_REPORT_PARAMS_ALL;

Dependencies

[top of page]

AP.AP_EXPENSE_REPORT_PARAMS_ALL does not reference any database object

AP.AP_EXPENSE_REPORT_PARAMS_ALL is referenced by following:

AP: AP_EXPENSE_REPORT_PARAMS_ALL#