1. Tables and Views for Project Management
  2. PJB_XLA_LINKS_REF_V

PJB_XLA_LINKS_REF_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

CONTRACT_PROJECT_LINKAGE_ID

CO_PR_LINK_ATTRIBUTE_CATEGORY

CONT_PROJ_LINK_ATTRIBUTE1

CONT_PROJ_LINK_ATTRIBUTE2

CONT_PROJ_LINK_ATTRIBUTE3

CONT_PROJ_LINK_ATTRIBUTE4

CONT_PROJ_LINK_ATTRIBUTE5

CONT_PROJ_LINK_ATTRIBUTE6

CONT_PROJ_LINK_ATTRIBUTE7

CONT_PROJ_LINK_ATTRIBUTE8

CONT_PROJ_LINK_ATTRIBUTE9

CONT_PROJ_LINK_ATTRIBUTE10

CONT_PROJ_LINK_ATTRIBUTE11

CONT_PROJ_LINK_ATTRIBUTE12

CONT_PROJ_LINK_ATTRIBUTE13

CONT_PROJ_LINK_ATTRIBUTE14

CONT_PROJ_LINK_ATTRIBUTE15

CONT_PROJ_LINK_ATTRIBUTE16

CONT_PROJ_LINK_ATTRIBUTE17

CONT_PROJ_LINK_ATTRIBUTE18

CONT_PROJ_LINK_ATTRIBUTE19

CONT_PROJ_LINK_ATTRIBUTE20

CONT_PROJ_LINK_ATTRIBUTE21

CONT_PROJ_LINK_ATTRIBUTE22

CONT_PROJ_LINK_ATTRIBUTE23

CONT_PROJ_LINK_ATTRIBUTE24

CONT_PROJ_LINK_ATTRIBUTE25

CONT_PROJ_LINK_ATTRIBUTE26

CONT_PROJ_LINK_ATTRIBUTE27

CONT_PROJ_LINK_ATTRIBUTE28

CONT_PROJ_LINK_ATTRIBUTE29

CONT_PROJ_LINK_ATTRIBUTE30

Query

SQL_Statement

SELECT

ContProjLink.LINK_ID CONTRACT_PROJECT_LINKAGE_ID,

ContProjLink.ATTRIBUTE_CATEGORY CO_PR_LINK_ATTRIBUTE_CATEGORY,

ContProjLink.ATTRIBUTE1 CONT_PROJ_LINK_ATTRIBUTE1,

ContProjLink.ATTRIBUTE2 CONT_PROJ_LINK_ATTRIBUTE2,

ContProjLink.ATTRIBUTE3 CONT_PROJ_LINK_ATTRIBUTE3,

ContProjLink.ATTRIBUTE4 CONT_PROJ_LINK_ATTRIBUTE4,

ContProjLink.ATTRIBUTE5 CONT_PROJ_LINK_ATTRIBUTE5,

ContProjLink.ATTRIBUTE6 CONT_PROJ_LINK_ATTRIBUTE6,

ContProjLink.ATTRIBUTE7 CONT_PROJ_LINK_ATTRIBUTE7,

ContProjLink.ATTRIBUTE8 CONT_PROJ_LINK_ATTRIBUTE8,

ContProjLink.ATTRIBUTE9 CONT_PROJ_LINK_ATTRIBUTE9,

ContProjLink.ATTRIBUTE10 CONT_PROJ_LINK_ATTRIBUTE10,

ContProjLink.ATTRIBUTE11 CONT_PROJ_LINK_ATTRIBUTE11,

ContProjLink.ATTRIBUTE12 CONT_PROJ_LINK_ATTRIBUTE12,

ContProjLink.ATTRIBUTE13 CONT_PROJ_LINK_ATTRIBUTE13,

ContProjLink.ATTRIBUTE14 CONT_PROJ_LINK_ATTRIBUTE14,

ContProjLink.ATTRIBUTE15 CONT_PROJ_LINK_ATTRIBUTE15,

ContProjLink.ATTRIBUTE16 CONT_PROJ_LINK_ATTRIBUTE16,

ContProjLink.ATTRIBUTE17 CONT_PROJ_LINK_ATTRIBUTE17,

ContProjLink.ATTRIBUTE18 CONT_PROJ_LINK_ATTRIBUTE18,

ContProjLink.ATTRIBUTE19 CONT_PROJ_LINK_ATTRIBUTE19,

ContProjLink.ATTRIBUTE20 CONT_PROJ_LINK_ATTRIBUTE20,

ContProjLink.ATTRIBUTE21 CONT_PROJ_LINK_ATTRIBUTE21,

ContProjLink.ATTRIBUTE22 CONT_PROJ_LINK_ATTRIBUTE22,

ContProjLink.ATTRIBUTE23 CONT_PROJ_LINK_ATTRIBUTE23,

ContProjLink.ATTRIBUTE24 CONT_PROJ_LINK_ATTRIBUTE24,

ContProjLink.ATTRIBUTE25 CONT_PROJ_LINK_ATTRIBUTE25,

ContProjLink.ATTRIBUTE26 CONT_PROJ_LINK_ATTRIBUTE26,

ContProjLink.ATTRIBUTE27 CONT_PROJ_LINK_ATTRIBUTE27,

ContProjLink.ATTRIBUTE28 CONT_PROJ_LINK_ATTRIBUTE28,

ContProjLink.ATTRIBUTE29 CONT_PROJ_LINK_ATTRIBUTE29,

ContProjLink.ATTRIBUTE30 CONT_PROJ_LINK_ATTRIBUTE30

FROM

PJB_CNTRCT_PROJ_LINKS ContProjLink,

OKC_K_LINES_B ContLine

WHERE ContLine.ID = ContProjLink.CONTRACT_LINE_ID

AND ContProjLink.MAJOR_VERSION = ContLine.MAJOR_VERSION

AND ContLine.VERSION_TYPE IN ('A','C')

AND ContLine.STS_CODE IN ('ACTIVE','CLOSED','EXPIRED','HOLD')