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: ViewPA.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
LATEST_EFF_PUBLISHED_FLAG VARCHAR2 (1) Yes Latest effective published version
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
,      LATEST_EFF_PUBLISHED_FLAG
FROM APPS.PA_STRUCT_VERSIONS_LOV_AMG_V;

Dependencies

[top of page]

APPS.PA_STRUCT_VERSIONS_LOV_AMG_V references the following:

SchemaAPPS
ViewPA_LOOKUPS
SynonymPA_PROJ_ELEM_VER_STRUCTURE
SynonymPA_PROJ_STRUCTURE_TYPES
SynonymPA_STRUCTURE_TYPES

APPS.PA_STRUCT_VERSIONS_LOV_AMG_V is not referenced by any database object