機械翻訳について

ACD_PROP_PROJ_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: ACD

• オブジェクト・タイプ: VIEW

列

名前
PROPOSAL_ID PROJECT_ID

問合せ

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