[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
APPS.PA_FIN_STRUCTURE_VERSIONS_V is not referenced by any database object
|
|
|