VIEW: APPS.PA_FINANCIAL_OPTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'