DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_STRUCTURE_VERSION_NAMES_V

Object Details
Object Name: PA_STRUCTURE_VERSION_NAMES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_STRUCTURE_VERSION_NAMES_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
STRUCTURE_VERSION_NAME VARCHAR2 (240) Yes User-defined long name of the structure version
STRUCTURE_VERSION_NUMBER NUMBER
Yes User-defined number that uniquely identifies the structure version within a project
ELEMENT_VERSION_ID NUMBER (15) Yes The identifier for the project structure version
PROJ_ELEMENT_ID NUMBER (15) Yes The identifier of the project structure to which the element belongs
STRUCTURE_NAME VARCHAR2 (240) Yes The name of the structure to which the element version belongs
PROJECT_ID NUMBER (15) Yes The identifier of the project
PUBLISHED_DATE DATE

The date that the structure version was published
STATUS_CODE VARCHAR2 (150)
Query Text

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


SELECT STRUCTURE_VERSION_NAME
,      STRUCTURE_VERSION_NUMBER
,      ELEMENT_VERSION_ID
,      PROJ_ELEMENT_ID
,      STRUCTURE_NAME
,      PROJECT_ID
,      PUBLISHED_DATE
,      STATUS_CODE
FROM APPS.PA_STRUCTURE_VERSION_NAMES_V;

Dependencies

[top of page]

APPS.PA_STRUCTURE_VERSION_NAMES_V references the following:

SchemaAPPS
SynonymPA_PROJ_ELEMENTS
SynonymPA_PROJ_ELEM_VER_STRUCTURE

APPS.PA_STRUCTURE_VERSION_NAMES_V is not referenced by any database object