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_ORGANIZATIONS

Object Details

Object Name:	PAFV_ORGANIZATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_ORGANIZATIONS
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

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes	The name of the business group.
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	The name of the organization
DATE_FROM	DATE		Yes	The start date of the organization
DATE_TO	DATE			The end date of the organization
INTERNAL_ADDRESS_LINE	VARCHAR2	(80)		The internal address of the organization
COMMENTS	CLOB	(4000)		General remarks and comments.
_LA:INTERNAL_EXTERNAL_FLAG	CHAR	(65)		Identifies whether the organization is treated as an employment unit within the business group
_LA:TYPE	CHAR	(46)		Forecast period type. Indicates whether the forecast period ranges are GL Period or date ranges.
LOCATION_NAME	VARCHAR2	(60)		The name of the location
ORGANIZATION_USE_TYPE_CODE	VARCHAR2	(30)	Yes	The purpose code for which the organization was used.
_LA:ORG_USE_TYPE	CHAR	(117)		The purpose description for which the organization was used.
INACTIVE_DATE	DATE			Date on which the organization becomes inactive in Projects Accounting.
_DF	CHAR	(34)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Unique identifier for Business Group
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)		Unique identifier for Cost Allocation Keyflex
LOCATION_ID	NUMBER	(15)		Unique identifier for Location
ORGANIZATION_ID	NUMBER	(15)	Yes	Unique identifier for the Organization
ORG_ID	NUMBER			Unique identifier for the Organization.
SOFT_CODING_KEYFLEX_ID	NUMBER	(15)		Unique identifier for Soft Coding Key flexfields

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      ORGANIZATION_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS_LINE
,      COMMENTS
,      _LA:INTERNAL_EXTERNAL_FLAG
,      _LA:TYPE
,      LOCATION_NAME
,      ORGANIZATION_USE_TYPE_CODE
,      _LA:ORG_USE_TYPE
,      INACTIVE_DATE
,      _DF
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      ORG_ID
,      SOFT_CODING_KEYFLEX_ID
FROM APPS.PAFV_ORGANIZATIONS;

Dependencies

[top of page]

APPS.PAFV_ORGANIZATIONS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL_TL; PA_ALL_ORGANIZATIONS

APPS.PAFV_ORGANIZATIONS is not referenced by any database object