View: PA_FINANCIAL_OPTIONS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_FINANCIAL_OPTIONS_V

View Text

SELECT PPWA.PROJECT_ID
, PPWA.PROJ_ELEMENT_ID
, PPE.NAME
, PPWA.WP_DEFAULT_DISPLAY_LVL
, PPPA.PROJ_PROGRESS_ATTR_ID
, PPPA.RECORD_VERSION_NUMBER
, PPWA.RECORD_VERSION_NUMBER
, PPE.RECORD_VERSION_NUMBER
, PPPA.TASK_WEIGHT_BASIS_CODE
FROM PA_PROJ_WORKPLAN_ATTR PPWA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_PROGRESS_ATTR PPPA
WHERE PPWA.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID <> 0
AND PPPA.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPPA.OBJECT_ID = PPE.PROJ_ELEMENT_ID
AND PPPA.PROJECT_ID = PPE.PROJECT_ID
AND PPPA.STRUCTURE_TYPE = 'FINANCIAL'

Columns