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_STRUCT_VERSIONS_LOV_AMG_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view provides a list of structure versions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STRUCTURE_VERSION_NAME	VARCHAR2	(240)	Yes	User-defined name of the structure version
STRUCTURE_VERSION_NUMBER	NUMBER		Yes	System-generated structure version number
STRUCTURE_VERSION_ID	NUMBER	(15)	Yes	Unique identifier for the element version
STRUCTURE_TYPE	VARCHAR2	(80)	Yes	Project structure type class
STRUCTURE_ID	NUMBER	(15)	Yes	Unique identifier for the structure version attributes
PROJECT_ID	NUMBER	(15)	Yes	Unique identifier of the project to which the structure version attributes belong
STATUS_CODE	VARCHAR2	(150)		Status of the structure version
STRUCTURE_TYPE_CLASS_CODE	VARCHAR2	(30)	Yes	Class code of structure type

Query Text

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


SELECT STRUCTURE_VERSION_NAME
,      STRUCTURE_VERSION_NUMBER
,      STRUCTURE_VERSION_ID
,      STRUCTURE_TYPE
,      STRUCTURE_ID
,      PROJECT_ID
,      STATUS_CODE
,      STRUCTURE_TYPE_CLASS_CODE
FROM APPS.PA_STRUCT_VERSIONS_LOV_AMG_V;

Dependencies

[top of page]

APPS.PA_STRUCT_VERSIONS_LOV_AMG_V references the following:

APPS: PA_LOOKUPS; PA_PROJ_ELEM_VER_STRUCTURE; PA_PROJ_STRUCTURE_TYPES; PA_STRUCTURE_TYPES

APPS.PA_STRUCT_VERSIONS_LOV_AMG_V is not referenced by any database object