VIEW: APPS.PA_DELIVERABLES_TASKS_V

Source

View Text - Preformatted

SELECT PPE.PROJ_ELEMENT_ID , PPE.NAME , PPE.ELEMENT_NUMBER , PEV.WBS_NUMBER , PPE.PROJECT_ID , PEV.PARENT_STRUCTURE_VERSION_ID , PPE.RECORD_VERSION_NUMBER FROM pa_proj_elements ppe ,pa_proj_element_versions pev WHERE ppe.object_type='PA_TASKS' AND ppe.proj_element_id = pev.proj_element_id AND ppe.project_id = pev.project_id

View Text - HTML Formatted

SELECT PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PEV.WBS_NUMBER
, PPE.PROJECT_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, PPE.RECORD_VERSION_NUMBER
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
WHERE PPE.OBJECT_TYPE='PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PEV.PROJECT_ID