[Home] [Help]
View: PA_STRUCTURE_NAMES_V
Product: | PA - Projects |
Description: | PA_STRUCTURE_NAMES_V selects structure name and structure number. - For future use |
Implementation/DBA Data: |
APPS.PA_STRUCTURE_NAMES_V
|
View Text
SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPA.NAME
, PST.STRUCTURE_TYPE_ID
, LU1.MEANING
, LU1.LOOKUP_CODE
, LU2.MEANING
, LU2.LOOKUP_CODE
, ST.STRUCTURE_TYPE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_STRUCTURE_TYPES PST
, PA_PROJECTS_ALL PPA
, FND_LOOKUPS LU1
, FND_LOOKUPS LU2
, PA_STRUCTURE_TYPES ST
WHERE PPE.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPE.PROJ_ELEMENT_ID = PST.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND LU1.LOOKUP_TYPE = 'YES_NO'
AND LU2.LOOKUP_TYPE = 'YES_NO'
AND LU1.LOOKUP_CODE = PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE(PST.PROJ_ELEMENT_ID
, 'WORKPLAN')
AND LU2.LOOKUP_CODE = PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE(PST.PROJ_ELEMENT_ID
, 'FINANCIAL')
AND ST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PPE.PROJECT_ID <> 0
Columns
Name |
STRUCTURE_NAME |
ELEMENT_NUMBER |
PROJ_ELEMENT_ID |
PROJECT_ID |
PROJECT_NAME |
STRUCTURE_TYPE_ID |
WORKPLAN |
WORKPLAN_FLAG |
FINANCIAL |
FINANCIAL_FLAG |
STRUCTURE_TYPE |