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]

VIEW: APPS.PAFV_EXPENDITURE_GROUPS

Object Details

Object Name:	PAFV_EXPENDITURE_GROUPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_EXPENDITURE_GROUPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

This shows information about groups or batches of user-entered pre-approved expenditures.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_GROUP	VARCHAR2	(240)	Yes	Expenditure Group
_LA:STATUS	CHAR	(77)		Status
DESCRIPTION	VARCHAR2	(250)		Description
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(80)	Yes	Expenditure Type Class
EXPENDITURE_ENDING_DATE	DATE		Yes	Expenditure Ending Date
CONTROL_COUNT	VARCHAR2	(20)		Control Count
CONTROL_TOTAL_AMOUNT	NUMBER	(22)		Control Total Amount
TRANSACTION_SOURCE	VARCHAR2	(30)		Transaction Source
TRANSACTION_SOURCE_DESCRIPTION	VARCHAR2	(240)		Transaction Source Description
ORG_ID	NUMBER	(15)		Unique identifier for Organization
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.

Query Text

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


SELECT EXPENDITURE_GROUP
,      _LA:STATUS
,      DESCRIPTION
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_ENDING_DATE
,      CONTROL_COUNT
,      CONTROL_TOTAL_AMOUNT
,      TRANSACTION_SOURCE
,      TRANSACTION_SOURCE_DESCRIPTION
,      ORG_ID
,      ORGANIZATION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PAFV_EXPENDITURE_GROUPS;

Dependencies

[top of page]

APPS.PAFV_EXPENDITURE_GROUPS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; PA_EXPENDITURE_GROUPS_ALL; PA_SYSTEM_LINKAGES; PA_TRANSACTION_SOURCES

APPS.PAFV_EXPENDITURE_GROUPS is not referenced by any database object