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.PA_FIN_STRUCTURE_VERSIONS_V

Object Details

Object Name:	PA_FIN_STRUCTURE_VERSIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_FIN_STRUCTURE_VERSIONS_V
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
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The identifier of the project element to which the element version belongs
ELEMENT_VERSION_ID	NUMBER	(15)	Yes	The identifier for the element version
PEV_STRUCTURE_ID	NUMBER	(15)	Yes	The identifier for the structure version attributes
PROJECT_ID	NUMBER		Yes	The identifier of the project to which the structure version attributes belong
STRUCTURE_NUMBER	VARCHAR2	(100)		The number that uniquely identifies the structure within a project
STRUCTURE_NAME	VARCHAR2	(240)	Yes	User-defined long name of the structure
STRUCTURE_VERSION_NUMBER	NUMBER		Yes	System generated structure version number
STRUCTURE_VERSION_NAME	VARCHAR2	(240)	Yes	User-defined name of the structure version
DESCRIPTION	VARCHAR2	(2000)		Description of the structure version
EFFECTIVE_DATE	DATE			The date that the structure version becomes effective
STATUS_CODE	VARCHAR2	(150)		The status of the structure version
STATUS_NAME	VARCHAR2	(80)	Yes	The meaning of the status of the structure version
LOCK_STATUS_CODE	VARCHAR2	(30)		The lock status of the structure version
LOCK_STATUS_NAME	VARCHAR2	(80)		The meaning of the lock status of the structure version
LOCKED_DATE	DATE			The date that the structure version was locked
LOCKED_BY_PERSON_ID	NUMBER	(15)		The user id of the person who has locked the structure version
LOCKED_BY_NAME	VARCHAR2	(240)		The name of the user who has currently locked the structure version
PUBLISHED_DATE	DATE			The date that the structure version was published
PUBLISHED_BY_PERSON_ID	NUMBER	(15)		The user id who published the structure version
PUBLISHED_NAME	VARCHAR2	(240)		The name of the user who published the structure version
ORIGINAL_FLAG	VARCHAR2	(1)	Yes	The flag that identifies the original baselined structure version
ORIGINAL_BASELINE_MEANING	VARCHAR2	(80)		The meaning of the original baseline state of the structure version
CURRENT_FLAG	VARCHAR2	(1)	Yes	The flag that identifies the original baselined structure version
CURRENT_BASELINE_MEANING	VARCHAR2	(80)		The meaning of the current baseline state of the structure version
LATEST_EFF_PUBLISHED_FLAG	VARCHAR2	(1)	Yes	Flag indicating that this structure version is the latest published version for each purpose
LATEST_EFF_PUBLISHED_MEANING	VARCHAR2	(80)		The meaning of the latest publish state of the structure version
STRUCTURE_TYPE	VARCHAR2	(150)	Yes	Uniquely identifies the structure type
STRUCTURE_REC_VERSION_NUMBER	NUMBER	(15)		Record version number of the structure
STRUC_VER_REC_VERSION_NUMBER	NUMBER	(15)		Record version number of the structure version
PEV_STRUC_REC_VERSION_NUMBER	NUMBER	(15)		Record version number of the structure verstion attribute
WBS_RECORD_VERSION_NUMBER	NUMBER	(15)		Record version number of the WBS structure
MANAGER_PERSON_ID	NUMBER	(15)
MANAGER_PERSON_NAME	VARCHAR2	(240)
BASELINE_START_DATE	DATE
BASELINE_FINISH_DATE	DATE
CHANGE_REASON_CODE	VARCHAR2	(30)
CHANGE_REASON_MEANING	VARCHAR2	(80)
BASELINE_AS_OF_DATE	DATE
WORKPLAN_FLAG	VARCHAR2	(4000)
CHILD_ELEMENT_FLAG	VARCHAR2	(4000)

Query Text

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


SELECT PROJ_ELEMENT_ID
,      ELEMENT_VERSION_ID
,      PEV_STRUCTURE_ID
,      PROJECT_ID
,      STRUCTURE_NUMBER
,      STRUCTURE_NAME
,      STRUCTURE_VERSION_NUMBER
,      STRUCTURE_VERSION_NAME
,      DESCRIPTION
,      EFFECTIVE_DATE
,      STATUS_CODE
,      STATUS_NAME
,      LOCK_STATUS_CODE
,      LOCK_STATUS_NAME
,      LOCKED_DATE
,      LOCKED_BY_PERSON_ID
,      LOCKED_BY_NAME
,      PUBLISHED_DATE
,      PUBLISHED_BY_PERSON_ID
,      PUBLISHED_NAME
,      ORIGINAL_FLAG
,      ORIGINAL_BASELINE_MEANING
,      CURRENT_FLAG
,      CURRENT_BASELINE_MEANING
,      LATEST_EFF_PUBLISHED_FLAG
,      LATEST_EFF_PUBLISHED_MEANING
,      STRUCTURE_TYPE
,      STRUCTURE_REC_VERSION_NUMBER
,      STRUC_VER_REC_VERSION_NUMBER
,      PEV_STRUC_REC_VERSION_NUMBER
,      WBS_RECORD_VERSION_NUMBER
,      MANAGER_PERSON_ID
,      MANAGER_PERSON_NAME
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      CHANGE_REASON_CODE
,      CHANGE_REASON_MEANING
,      BASELINE_AS_OF_DATE
,      WORKPLAN_FLAG
,      CHILD_ELEMENT_FLAG
FROM APPS.PA_FIN_STRUCTURE_VERSIONS_V;

Dependencies

[top of page]

APPS.PA_FIN_STRUCTURE_VERSIONS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_PROJECT_STATUSES; PA_PROJECT_STRUCTURE_UTILS - show dependent code; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENTS_UTILS - show dependent code; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_STRUCTURE; PA_PROJ_STRUCTURE_TYPES; PA_STRUCTURE_TYPES; PER_ALL_PEOPLE_F

APPS.PA_FIN_STRUCTURE_VERSIONS_V is not referenced by any database object