1. Tables and Views for Project Management
  2. PJB_XLA_LINKED_TASK_REF_V

PJB_XLA_LINKED_TASK_REF_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

LINKED_TASK_ID

LINKED_TASK_NUMBER

LINKED_TASK_NAME

Query

SQL_Statement

SELECT

ProjElem.PROJ_ELEMENT_ID LINKED_TASK_ID,

ProjElem.ELEMENT_NUMBER LINKED_TASK_NUMBER,

ProjElem.PROJ_ELEMENT_ID LINKED_TASK_NAME

FROM

PJF_PROJ_ELEMENTS_B ProjElem

WHERE

ProjElem.ELEMENT_TYPE = 'FINANCIAL'