1. Tables and Views for Project Management
  2. PJC_XLA_PROJECT_ORG_V

PJC_XLA_PROJECT_ORG_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PROJECT_ORGANIZATION_ID

PROJECT_ORG_ATTRIBUTE_CATEGORY

PROJECT_ORG_ATTRIBUTE1

PROJECT_ORG_ATTRIBUTE2

PROJECT_ORG_ATTRIBUTE3

PROJECT_ORG_ATTRIBUTE4

PROJECT_ORG_ATTRIBUTE5

PROJECT_ORG_ATTRIBUTE6

PROJECT_ORG_ATTRIBUTE7

PROJECT_ORG_ATTRIBUTE8

PROJECT_ORG_ATTRIBUTE9

PROJECT_ORG_ATTRIBUTE10

PROJECT_ORG_ATTRIBUTE11

PROJECT_ORG_ATTRIBUTE12

PROJECT_ORG_ATTRIBUTE13

PROJECT_ORG_ATTRIBUTE14

PROJECT_ORG_ATTRIBUTE15

PROJECT_ORG_ATTRIBUTE16

PROJECT_ORG_ATTRIBUTE17

PROJECT_ORG_ATTRIBUTE18

PROJECT_ORG_ATTRIBUTE19

PROJECT_ORG_ATTRIBUTE20

PROJECT_ORG_ATTRIBUTE21

PROJECT_ORG_ATTRIBUTE22

PROJECT_ORG_ATTRIBUTE23

PROJECT_ORG_ATTRIBUTE24

PROJECT_ORG_ATTRIBUTE25

PROJECT_ORG_ATTRIBUTE26

PROJECT_ORG_ATTRIBUTE27

PROJECT_ORG_ATTRIBUTE28

PROJECT_ORG_ATTRIBUTE29

PROJECT_ORG_ATTRIBUTE30

PROJECT_ORG_ATTR_NUMBER1

PROJECT_ORG_ATTR_NUMBER2

PROJECT_ORG_ATTR_NUMBER3

PROJECT_ORG_ATTR_NUMBER4

PROJECT_ORG_ATTR_NUMBER5

PROJECT_ORG_ATTR_NUMBER6

PROJECT_ORG_ATTR_NUMBER7

PROJECT_ORG_ATTR_NUMBER8

PROJECT_ORG_ATTR_NUMBER9

PROJECT_ORG_ATTR_NUMBER10

PROJECT_ORG_ATTR_NUMBER11

PROJECT_ORG_ATTR_NUMBER12

PROJECT_ORG_ATTR_NUMBER13

PROJECT_ORG_ATTR_NUMBER14

PROJECT_ORG_ATTR_NUMBER15

PROJECT_ORG_ATTR_NUMBER16

PROJECT_ORG_ATTR_NUMBER17

PROJECT_ORG_ATTR_NUMBER18

PROJECT_ORG_ATTR_NUMBER19

PROJECT_ORG_ATTR_NUMBER20

PROJECT_ORG_ATTR_DATE1

PROJECT_ORG_ATTR_DATE2

PROJECT_ORG_ATTR_DATE3

PROJECT_ORG_ATTR_DATE4

PROJECT_ORG_ATTR_DATE5

PROJECT_ORG_ATTR_DATE6

PROJECT_ORG_ATTR_DATE7

PROJECT_ORG_ATTR_DATE8

PROJECT_ORG_ATTR_DATE9

PROJECT_ORG_ATTR_DATE10

PROJECT_ORG_ATTR_DATE11

PROJECT_ORG_ATTR_DATE12

PROJECT_ORG_ATTR_DATE13

PROJECT_ORG_ATTR_DATE14

PROJECT_ORG_ATTR_DATE15

Query

SQL_Statement

SELECT

ou.ORGANIZATION_ID project_organization_id ,

ou.ATTRIBUTE_CATEGORY Project_Org_attribute_Category,

ou.ATTRIBUTE1 Project_Org_attribute1,

ou.ATTRIBUTE2 Project_Org_attribute2,

ou.ATTRIBUTE3 Project_Org_attribute3,

ou.ATTRIBUTE4 Project_Org_attribute4,

ou.ATTRIBUTE5 Project_Org_attribute5,

ou.ATTRIBUTE6 Project_Org_attribute6,

ou.ATTRIBUTE7 Project_Org_attribute7,

ou.ATTRIBUTE8 Project_Org_attribute8,

ou.ATTRIBUTE9 Project_Org_attribute9,

ou.ATTRIBUTE10 Project_Org_attribute10,

ou.ATTRIBUTE11 Project_Org_attribute11,

ou.ATTRIBUTE12 Project_Org_attribute12,

ou.ATTRIBUTE13 Project_Org_attribute13,

ou.ATTRIBUTE14 Project_Org_attribute14,

ou.ATTRIBUTE15 Project_Org_attribute15,

ou.ATTRIBUTE16 Project_Org_attribute16,

ou.ATTRIBUTE17 Project_Org_attribute17,

ou.ATTRIBUTE18 Project_Org_attribute18,

ou.ATTRIBUTE19 Project_Org_attribute19,

ou.ATTRIBUTE20 Project_Org_attribute20,

ou.ATTRIBUTE21 Project_Org_attribute21,

ou.ATTRIBUTE22 Project_Org_attribute22,

ou.ATTRIBUTE23 Project_Org_attribute23,

ou.ATTRIBUTE24 Project_Org_attribute24,

ou.ATTRIBUTE25 Project_Org_attribute25,

ou.ATTRIBUTE26 Project_Org_attribute26,

ou.ATTRIBUTE27 Project_Org_attribute27,

ou.ATTRIBUTE28 Project_Org_attribute28,

ou.ATTRIBUTE29 Project_Org_attribute29,

ou.ATTRIBUTE30 Project_Org_attribute30,

ou.ATTRIBUTE_NUMBER1 Project_Org_Attr_number1,

ou.ATTRIBUTE_NUMBER2 Project_Org_Attr_number2,

ou.ATTRIBUTE_NUMBER3 Project_Org_Attr_number3,

ou.ATTRIBUTE_NUMBER4 Project_Org_Attr_number4,

ou.ATTRIBUTE_NUMBER5 Project_Org_Attr_number5,

ou.ATTRIBUTE_NUMBER6 Project_Org_Attr_number6,

ou.ATTRIBUTE_NUMBER7 Project_Org_Attr_number7,

ou.ATTRIBUTE_NUMBER8 Project_Org_Attr_number8,

ou.ATTRIBUTE_NUMBER9 Project_Org_Attr_number9,

ou.ATTRIBUTE_NUMBER10 Project_Org_Attr_number10,

ou.ATTRIBUTE_NUMBER11 Project_Org_Attr_number11,

ou.ATTRIBUTE_NUMBER12 Project_Org_Attr_number12,

ou.ATTRIBUTE_NUMBER13 Project_Org_Attr_number13,

ou.ATTRIBUTE_NUMBER14 Project_Org_Attr_number14,

ou.ATTRIBUTE_NUMBER15 Project_Org_Attr_number15,

ou.ATTRIBUTE_NUMBER16 Project_Org_Attr_number16,

ou.ATTRIBUTE_NUMBER17 Project_Org_Attr_number17,

ou.ATTRIBUTE_NUMBER18 Project_Org_Attr_number18,

ou.ATTRIBUTE_NUMBER19 Project_Org_Attr_number19,

ou.ATTRIBUTE_NUMBER20 Project_Org_Attr_number20,

ou.ATTRIBUTE_DATE1 Project_Org_Attr_date1,

ou.ATTRIBUTE_DATE2 Project_Org_Attr_date2,

ou.ATTRIBUTE_DATE3 Project_Org_Attr_date3,

ou.ATTRIBUTE_DATE4 Project_Org_Attr_date4,

ou.ATTRIBUTE_DATE5 Project_Org_Attr_date5,

ou.ATTRIBUTE_DATE6 Project_Org_Attr_date6,

ou.ATTRIBUTE_DATE7 Project_Org_Attr_date7,

ou.ATTRIBUTE_DATE8 Project_Org_Attr_date8,

ou.ATTRIBUTE_DATE9 Project_Org_Attr_date9,

ou.ATTRIBUTE_DATE10 Project_Org_Attr_date10,

ou.ATTRIBUTE_DATE11 Project_Org_Attr_date11,

ou.ATTRIBUTE_DATE12 Project_Org_Attr_date12,

ou.ATTRIBUTE_DATE13 Project_Org_Attr_date13,

ou.ATTRIBUTE_DATE14 Project_Org_Attr_date14,

ou.ATTRIBUTE_DATE15 Project_Org_Attr_date15

FROM

HR_ALL_ORGANIZATION_UNITS_F ou

WHERE

trunc(sysdate) between ou.effective_start_date and ou.effective_end_Date