ACD_PROP_PROJ_V

Details

• Schema: FUSION

• Object owner: ACD

• Object type: VIEW

Columns

Name
PROPOSAL_ID PROJECT_ID

Query

SQL_Statement

SELECT poa.proposal_id, pel.project_id FROM (SELECT associated_object_id as proposal_id, object_id as task_id FROM fusion.pje_object_associations WHERE associated_object_sub_type_id IN ( SELECT DELIVERABLE_TYPE_ID FROM PJE_DELIVERABLE_TYPES_VL PROPOSALCLASS WHERE PROPOSALCLASS.DELIVERABLE_TYPE_CLASS='PLM_PROPOSAL' ) ) poa, pjf_proj_elements_b pel WHERE pel.proj_element_id=poa.task_id GROUP BY poa.proposal_id, pel.project_id