1. Tables and Views for Project Management
  2. PJC_XLA_EXP_ORG_REF_V

PJC_XLA_EXP_ORG_REF_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

EXPENDITURE_ORGANIZATION_ID

EXP_ORGANIZATION_NAME

EXP_ORG_COMPANY

EXP_ORG_COST_CENTER

EXP_ORG_ATTRIBUTE_CATEGORY

EXP_ORG_ATTRIBUTE1

EXP_ORG_ATTRIBUTE2

EXP_ORG_ATTRIBUTE3

EXP_ORG_ATTRIBUTE4

EXP_ORG_ATTRIBUTE5

EXP_ORG_ATTRIBUTE6

EXP_ORG_ATTRIBUTE7

EXP_ORG_ATTRIBUTE8

EXP_ORG_ATTRIBUTE9

EXP_ORG_ATTRIBUTE10

EXP_ORG_ATTRIBUTE11

EXP_ORG_ATTRIBUTE12

EXP_ORG_ATTRIBUTE13

EXP_ORG_ATTRIBUTE14

EXP_ORG_ATTRIBUTE15

EXP_ORG_ATTRIBUTE16

EXP_ORG_ATTRIBUTE17

EXP_ORG_ATTRIBUTE18

EXP_ORG_ATTRIBUTE19

EXP_ORG_ATTRIBUTE20

EXP_ORG_ATTRIBUTE21

EXP_ORG_ATTRIBUTE22

EXP_ORG_ATTRIBUTE23

EXP_ORG_ATTRIBUTE24

EXP_ORG_ATTRIBUTE25

EXP_ORG_ATTRIBUTE26

EXP_ORG_ATTRIBUTE27

EXP_ORG_ATTRIBUTE28

EXP_ORG_ATTRIBUTE29

EXP_ORG_ATTRIBUTE30

EXP_ORG_ATTR_NUMBER1

EXP_ORG_ATTR_NUMBER2

EXP_ORG_ATTR_NUMBER3

EXP_ORG_ATTR_NUMBER4

EXP_ORG_ATTR_NUMBER5

EXP_ORG_ATTR_NUMBER6

EXP_ORG_ATTR_NUMBER7

EXP_ORG_ATTR_NUMBER8

EXP_ORG_ATTR_NUMBER9

EXP_ORG_ATTR_NUMBER10

EXP_ORG_ATTR_NUMBER11

EXP_ORG_ATTR_NUMBER12

EXP_ORG_ATTR_NUMBER13

EXP_ORG_ATTR_NUMBER14

EXP_ORG_ATTR_NUMBER15

EXP_ORG_ATTR_NUMBER16

EXP_ORG_ATTR_NUMBER17

EXP_ORG_ATTR_NUMBER18

EXP_ORG_ATTR_NUMBER19

EXP_ORG_ATTR_NUMBER20

EXP_ORG_ATTR_DATE1

EXP_ORG_ATTR_DATE2

EXP_ORG_ATTR_DATE3

EXP_ORG_ATTR_DATE4

EXP_ORG_ATTR_DATE5

EXP_ORG_ATTR_DATE6

EXP_ORG_ATTR_DATE7

EXP_ORG_ATTR_DATE8

EXP_ORG_ATTR_DATE9

EXP_ORG_ATTR_DATE10

EXP_ORG_ATTR_DATE11

EXP_ORG_ATTR_DATE12

EXP_ORG_ATTR_DATE13

EXP_ORG_ATTR_DATE14

EXP_ORG_ATTR_DATE15

Query

SQL_Statement

SELECT hroi.organization_id expenditure_organization_id,

hroi.organization_id exp_organization_name,

pjc_accounting_pvt.get_company_info(hroi.organization_id) exp_org_company,

pjc_accounting_pvt.get_costcenter_info(hroi.organization_id) exp_org_cost_center,

hroi.ATTRIBUTE_CATEGORY Exp_Org_attribute_Category,

hroi.ATTRIBUTE1 Exp_Org_attribute1,

hroi.ATTRIBUTE2 Exp_Org_attribute2,

hroi.ATTRIBUTE3 Exp_Org_attribute3,

hroi.ATTRIBUTE4 Exp_Org_attribute4,

hroi.ATTRIBUTE5 Exp_Org_attribute5,

hroi.ATTRIBUTE6 Exp_Org_attribute6,

hroi.ATTRIBUTE7 Exp_Org_attribute7,

hroi.ATTRIBUTE8 Exp_Org_attribute8,

hroi.ATTRIBUTE9 Exp_Org_attribute9,

hroi.ATTRIBUTE10 Exp_Org_attribute10,

hroi.ATTRIBUTE11 Exp_Org_attribute11,

hroi.ATTRIBUTE12 Exp_Org_attribute12,

hroi.ATTRIBUTE13 Exp_Org_attribute13,

hroi.ATTRIBUTE14 Exp_Org_attribute14,

hroi.ATTRIBUTE15 Exp_Org_attribute15,

hroi.ATTRIBUTE16 Exp_Org_attribute16,

hroi.ATTRIBUTE17 Exp_Org_attribute17,

hroi.ATTRIBUTE18 Exp_Org_attribute18,

hroi.ATTRIBUTE19 Exp_Org_attribute19,

hroi.ATTRIBUTE20 Exp_Org_attribute20,

hroi.ATTRIBUTE21 Exp_Org_attribute21,

hroi.ATTRIBUTE22 Exp_Org_attribute22,

hroi.ATTRIBUTE23 Exp_Org_attribute23,

hroi.ATTRIBUTE24 Exp_Org_attribute24,

hroi.ATTRIBUTE25 Exp_Org_attribute25,

hroi.ATTRIBUTE26 Exp_Org_attribute26,

hroi.ATTRIBUTE27 Exp_Org_attribute27,

hroi.ATTRIBUTE28 Exp_Org_attribute28,

hroi.ATTRIBUTE29 Exp_Org_attribute29,

hroi.ATTRIBUTE30 Exp_Org_attribute30,

hroi.ATTRIBUTE_NUMBER1 Exp_Org_Attr_number1,

hroi.ATTRIBUTE_NUMBER2 Exp_Org_Attr_number2,

hroi.ATTRIBUTE_NUMBER3 Exp_Org_Attr_number3,

hroi.ATTRIBUTE_NUMBER4 Exp_Org_Attr_number4,

hroi.ATTRIBUTE_NUMBER5 Exp_Org_Attr_number5,

hroi.ATTRIBUTE_NUMBER6 Exp_Org_Attr_number6,

hroi.ATTRIBUTE_NUMBER7 Exp_Org_Attr_number7,

hroi.ATTRIBUTE_NUMBER8 Exp_Org_Attr_number8,

hroi.ATTRIBUTE_NUMBER9 Exp_Org_Attr_number9,

hroi.ATTRIBUTE_NUMBER10 Exp_Org_Attr_number10,

hroi.ATTRIBUTE_NUMBER11 Exp_Org_Attr_number11,

hroi.ATTRIBUTE_NUMBER12 Exp_Org_Attr_number12,

hroi.ATTRIBUTE_NUMBER13 Exp_Org_Attr_number13,

hroi.ATTRIBUTE_NUMBER14 Exp_Org_Attr_number14,

hroi.ATTRIBUTE_NUMBER15 Exp_Org_Attr_number15,

hroi.ATTRIBUTE_NUMBER16 Exp_Org_Attr_number16,

hroi.ATTRIBUTE_NUMBER17 Exp_Org_Attr_number17,

hroi.ATTRIBUTE_NUMBER18 Exp_Org_Attr_number18,

hroi.ATTRIBUTE_NUMBER19 Exp_Org_Attr_number19,

hroi.ATTRIBUTE_NUMBER20 Exp_Org_Attr_number20,

hroi.ATTRIBUTE_DATE1 Exp_Org_Attr_date1,

hroi.ATTRIBUTE_DATE2 Exp_Org_Attr_date2,

hroi.ATTRIBUTE_DATE3 Exp_Org_Attr_date3,

hroi.ATTRIBUTE_DATE4 Exp_Org_Attr_date4,

hroi.ATTRIBUTE_DATE5 Exp_Org_Attr_date5,

hroi.ATTRIBUTE_DATE6 Exp_Org_Attr_date6,

hroi.ATTRIBUTE_DATE7 Exp_Org_Attr_date7,

hroi.ATTRIBUTE_DATE8 Exp_Org_Attr_date8,

hroi.ATTRIBUTE_DATE9 Exp_Org_Attr_date9,

hroi.ATTRIBUTE_DATE10 Exp_Org_Attr_date10,

hroi.ATTRIBUTE_DATE11 Exp_Org_Attr_date11,

hroi.ATTRIBUTE_DATE12 Exp_Org_Attr_date12,

hroi.ATTRIBUTE_DATE13 Exp_Org_Attr_date13,

hroi.ATTRIBUTE_DATE14 Exp_Org_Attr_date14,

hroi.ATTRIBUTE_DATE15 Exp_Org_Attr_date15

FROM hr_all_organization_units_f hroi

WHERE trunc(sysdate) between hroi.effective_start_date and hroi.effective_end_date