CST_XLA_PROJECT_SOURCES_REF

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ITEM_DATE EXPENDITURE_ORGANIZATION_ID WORK_TYPE_ID CONTRACT_ID CONTRACT_LINE_ID FUNDING_ALLOCATION_ID BILLABLE_FLAG CAPITALIZABLE_FLAG CONTEXT_CATEGORY USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE10 RESERVED_ATTRIBUTE1 RESERVED_ATTRIBUTE2 RESERVED_ATTRIBUTE3 RESERVED_ATTRIBUTE4 RESERVED_ATTRIBUTE5 RESERVED_ATTRIBUTE6 RESERVED_ATTRIBUTE7 RESERVED_ATTRIBUTE8 RESERVED_ATTRIBUTE9 RESERVED_ATTRIBUTE10 CST_INV_TRANSACTION_ID PROJECT_NUMBER PROJECT_NAME TASK_NUMBER TASK_NAME EXPENDITURE_TYPE_NAME PROJECT_ATTRIBUTE_CATEGORY PROJECT_ATTRIBUTE1 PROJECT_ATTRIBUTE2 PROJECT_ATTRIBUTE3 PROJECT_ATTRIBUTE4 PROJECT_ATTRIBUTE5 PROJECT_ATTRIBUTE6 PROJECT_ATTRIBUTE7 PROJECT_ATTRIBUTE8 PROJECT_ATTRIBUTE9 PROJECT_ATTRIBUTE10 PROJECT_ATTRIBUTE11 PROJECT_ATTRIBUTE12 PROJECT_ATTRIBUTE13 PROJECT_ATTRIBUTE14 PROJECT_ATTRIBUTE15 PROJECT_ATTRIBUTE16 PROJECT_ATTRIBUTE17 PROJECT_ATTRIBUTE18 PROJECT_ATTRIBUTE19 PROJECT_ATTRIBUTE20 PROJECT_ATTRIBUTE21 PROJECT_ATTRIBUTE22 PROJECT_ATTRIBUTE23 PROJECT_ATTRIBUTE24 PROJECT_ATTRIBUTE25 PROJECT_ATTRIBUTE26 PROJECT_ATTRIBUTE27 PROJECT_ATTRIBUTE28 PROJECT_ATTRIBUTE29 PROJECT_ATTRIBUTE30 PROJECT_ATTRIBUTE31 PROJECT_ATTRIBUTE32 PROJECT_ATTRIBUTE33 PROJECT_ATTRIBUTE34 PROJECT_ATTRIBUTE35 PROJECT_ATTRIBUTE36 PROJECT_ATTRIBUTE37 PROJECT_ATTRIBUTE38 PROJECT_ATTRIBUTE39 PROJECT_ATTRIBUTE40 PROJECT_ATTRIBUTE41 PROJECT_ATTRIBUTE42 PROJECT_ATTRIBUTE43 PROJECT_ATTRIBUTE44 PROJECT_ATTRIBUTE45 PROJECT_ATTRIBUTE46 PROJECT_ATTRIBUTE47 PROJECT_ATTRIBUTE48 PROJECT_ATTRIBUTE49 PROJECT_ATTRIBUTE50 PROJECT_ATTRIBUTE1_NUMBER PROJECT_ATTRIBUTE2_NUMBER PROJECT_ATTRIBUTE3_NUMBER PROJECT_ATTRIBUTE4_NUMBER PROJECT_ATTRIBUTE5_NUMBER PROJECT_ATTRIBUTE6_NUMBER PROJECT_ATTRIBUTE7_NUMBER PROJECT_ATTRIBUTE8_NUMBER PROJECT_ATTRIBUTE9_NUMBER PROJECT_ATTRIBUTE10_NUMBER PROJECT_ATTRIBUTE11_NUMBER PROJECT_ATTRIBUTE12_NUMBER PROJECT_ATTRIBUTE13_NUMBER PROJECT_ATTRIBUTE14_NUMBER PROJECT_ATTRIBUTE15_NUMBER PROJECT_ATTRIBUTE1_DATE PROJECT_ATTRIBUTE2_DATE PROJECT_ATTRIBUTE3_DATE PROJECT_ATTRIBUTE4_DATE PROJECT_ATTRIBUTE5_DATE PROJECT_ATTRIBUTE6_DATE PROJECT_ATTRIBUTE7_DATE PROJECT_ATTRIBUTE8_DATE PROJECT_ATTRIBUTE9_DATE PROJECT_ATTRIBUTE10_DATE PROJECT_ATTRIBUTE11_DATE PROJECT_ATTRIBUTE12_DATE PROJECT_ATTRIBUTE13_DATE PROJECT_ATTRIBUTE14_DATE PROJECT_ATTRIBUTE15_DATE TASK_ATTRIBUTE_CATEGORY TASK_ATTRIBUTE1 TASK_ATTRIBUTE2 TASK_ATTRIBUTE3 TASK_ATTRIBUTE4 TASK_ATTRIBUTE5 TASK_ATTRIBUTE6 TASK_ATTRIBUTE7 TASK_ATTRIBUTE8 TASK_ATTRIBUTE9 TASK_ATTRIBUTE10 TASK_ATTRIBUTE11 TASK_ATTRIBUTE12 TASK_ATTRIBUTE13 TASK_ATTRIBUTE14 TASK_ATTRIBUTE15 PROJECT_EXPENDITURE_ORG_ID PROJECT_OWNING_ORG_ID

Name

PROJECT_ID

TASK_ID

EXPENDITURE_TYPE_ID

EXPENDITURE_ITEM_DATE

EXPENDITURE_ORGANIZATION_ID

WORK_TYPE_ID

CONTRACT_ID

CONTRACT_LINE_ID

FUNDING_ALLOCATION_ID

BILLABLE_FLAG

CAPITALIZABLE_FLAG

CONTEXT_CATEGORY

USER_DEF_ATTRIBUTE1

USER_DEF_ATTRIBUTE2

USER_DEF_ATTRIBUTE3

USER_DEF_ATTRIBUTE4

USER_DEF_ATTRIBUTE5

USER_DEF_ATTRIBUTE6

USER_DEF_ATTRIBUTE7

USER_DEF_ATTRIBUTE8

USER_DEF_ATTRIBUTE9

USER_DEF_ATTRIBUTE10

RESERVED_ATTRIBUTE1

RESERVED_ATTRIBUTE2

RESERVED_ATTRIBUTE3

RESERVED_ATTRIBUTE4

RESERVED_ATTRIBUTE5

RESERVED_ATTRIBUTE6

RESERVED_ATTRIBUTE7

RESERVED_ATTRIBUTE8

RESERVED_ATTRIBUTE9

RESERVED_ATTRIBUTE10

CST_INV_TRANSACTION_ID

PROJECT_NUMBER

PROJECT_NAME

TASK_NUMBER

TASK_NAME

EXPENDITURE_TYPE_NAME

PROJECT_ATTRIBUTE_CATEGORY

PROJECT_ATTRIBUTE1

PROJECT_ATTRIBUTE2

PROJECT_ATTRIBUTE3

PROJECT_ATTRIBUTE4

PROJECT_ATTRIBUTE5

PROJECT_ATTRIBUTE6

PROJECT_ATTRIBUTE7

PROJECT_ATTRIBUTE8

PROJECT_ATTRIBUTE9

PROJECT_ATTRIBUTE10

PROJECT_ATTRIBUTE11

PROJECT_ATTRIBUTE12

PROJECT_ATTRIBUTE13

PROJECT_ATTRIBUTE14

PROJECT_ATTRIBUTE15

PROJECT_ATTRIBUTE16

PROJECT_ATTRIBUTE17

PROJECT_ATTRIBUTE18

PROJECT_ATTRIBUTE19

PROJECT_ATTRIBUTE20

PROJECT_ATTRIBUTE21

PROJECT_ATTRIBUTE22

PROJECT_ATTRIBUTE23

PROJECT_ATTRIBUTE24

PROJECT_ATTRIBUTE25

PROJECT_ATTRIBUTE26

PROJECT_ATTRIBUTE27

PROJECT_ATTRIBUTE28

PROJECT_ATTRIBUTE29

PROJECT_ATTRIBUTE30

PROJECT_ATTRIBUTE31

PROJECT_ATTRIBUTE32

PROJECT_ATTRIBUTE33

PROJECT_ATTRIBUTE34

PROJECT_ATTRIBUTE35

PROJECT_ATTRIBUTE36

PROJECT_ATTRIBUTE37

PROJECT_ATTRIBUTE38

PROJECT_ATTRIBUTE39

PROJECT_ATTRIBUTE40

PROJECT_ATTRIBUTE41

PROJECT_ATTRIBUTE42

PROJECT_ATTRIBUTE43

PROJECT_ATTRIBUTE44

PROJECT_ATTRIBUTE45

PROJECT_ATTRIBUTE46

PROJECT_ATTRIBUTE47

PROJECT_ATTRIBUTE48

PROJECT_ATTRIBUTE49

PROJECT_ATTRIBUTE50

PROJECT_ATTRIBUTE1_NUMBER

PROJECT_ATTRIBUTE2_NUMBER

PROJECT_ATTRIBUTE3_NUMBER

PROJECT_ATTRIBUTE4_NUMBER

PROJECT_ATTRIBUTE5_NUMBER

PROJECT_ATTRIBUTE6_NUMBER

PROJECT_ATTRIBUTE7_NUMBER

PROJECT_ATTRIBUTE8_NUMBER

PROJECT_ATTRIBUTE9_NUMBER

PROJECT_ATTRIBUTE10_NUMBER

PROJECT_ATTRIBUTE11_NUMBER

PROJECT_ATTRIBUTE12_NUMBER

PROJECT_ATTRIBUTE13_NUMBER

PROJECT_ATTRIBUTE14_NUMBER

PROJECT_ATTRIBUTE15_NUMBER

PROJECT_ATTRIBUTE1_DATE

PROJECT_ATTRIBUTE2_DATE

PROJECT_ATTRIBUTE3_DATE

PROJECT_ATTRIBUTE4_DATE

PROJECT_ATTRIBUTE5_DATE

PROJECT_ATTRIBUTE6_DATE

PROJECT_ATTRIBUTE7_DATE

PROJECT_ATTRIBUTE8_DATE

PROJECT_ATTRIBUTE9_DATE

PROJECT_ATTRIBUTE10_DATE

PROJECT_ATTRIBUTE11_DATE

PROJECT_ATTRIBUTE12_DATE

PROJECT_ATTRIBUTE13_DATE

PROJECT_ATTRIBUTE14_DATE

PROJECT_ATTRIBUTE15_DATE

TASK_ATTRIBUTE_CATEGORY

TASK_ATTRIBUTE1

TASK_ATTRIBUTE2

TASK_ATTRIBUTE3

TASK_ATTRIBUTE4

TASK_ATTRIBUTE5

TASK_ATTRIBUTE6

TASK_ATTRIBUTE7

TASK_ATTRIBUTE8

TASK_ATTRIBUTE9

TASK_ATTRIBUTE10

TASK_ATTRIBUTE11

TASK_ATTRIBUTE12

TASK_ATTRIBUTE13

TASK_ATTRIBUTE14

TASK_ATTRIBUTE15

PROJECT_EXPENDITURE_ORG_ID

PROJECT_OWNING_ORG_ID

Query

SQL_Statement
SELECT cit.pjc_project_id project_id, cit.pjc_task_id task_id, cit.pjc_expenditure_type_id expenditure_type_id, cit.pjc_expenditure_item_date expenditure_item_date, cit.pjc_organization_id expenditure_organization_id, cit.pjc_work_type_id work_type_id, cit.pjc_contract_id contract_id, cit.pjc_contract_line_id contract_line_id, cit.pjc_funding_allocation_id funding_allocation_id, cit.pjc_billable_flag billable_flag, cit.pjc_capitalizable_flag capitalizable_flag, cit.pjc_context_category context_category, cit.pjc_user_def_attribute1 user_def_attribute1, cit.pjc_user_def_attribute2 user_def_attribute2, cit.pjc_user_def_attribute3 user_def_attribute3, cit.pjc_user_def_attribute4 user_def_attribute4, cit.pjc_user_def_attribute5 user_def_attribute5, cit.pjc_user_def_attribute6 user_def_attribute6, cit.pjc_user_def_attribute7 user_def_attribute7, cit.pjc_user_def_attribute8 user_def_attribute8, cit.pjc_user_def_attribute9 user_def_attribute9, cit.pjc_user_def_attribute10 user_def_attribute10, cit.pjc_reserved_attribute1 reserved_attribute1, cit.pjc_reserved_attribute2 reserved_attribute2, cit.pjc_reserved_attribute3 reserved_attribute3, cit.pjc_reserved_attribute4 reserved_attribute4, cit.pjc_reserved_attribute5 reserved_attribute5, cit.pjc_reserved_attribute6 reserved_attribute6, cit.pjc_reserved_attribute7 reserved_attribute7, cit.pjc_reserved_attribute8 reserved_attribute8, cit.pjc_reserved_attribute9 reserved_attribute9, cit.pjc_reserved_attribute10 reserved_attribute10, cit.cst_inv_transaction_id cst_inv_transaction_id, ppa.segment1 project_number, ppa.name project_name, pt.task_number task_number, pt.task_name task_name, pet.expenditure_type_name expenditure_type_name, ppa.attribute_category project_attribute_category, ppa.attribute1 project_attribute1, ppa.attribute2 project_attribute2, ppa.attribute3 project_attribute3, ppa.attribute4 project_attribute4, ppa.attribute5 project_attribute5, ppa.attribute6 project_attribute6, ppa.attribute7 project_attribute7, ppa.attribute8 project_attribute8, ppa.attribute9 project_attribute9, ppa.attribute10 project_attribute10, ppa.attribute11 project_attribute11, ppa.attribute12 project_attribute12, ppa.attribute13 project_attribute13, ppa.attribute14 project_attribute14, ppa.attribute15 project_attribute15, ppa.attribute16 project_attribute16, ppa.attribute17 project_attribute17, ppa.attribute18 project_attribute18, ppa.attribute19 project_attribute19, ppa.attribute20 project_attribute20, ppa.attribute21 project_attribute21, ppa.attribute22 project_attribute22, ppa.attribute23 project_attribute23, ppa.attribute24 project_attribute24, ppa.attribute25 project_attribute25, ppa.attribute26 project_attribute26, ppa.attribute27 project_attribute27, ppa.attribute28 project_attribute28, ppa.attribute29 project_attribute29, ppa.attribute30 project_attribute30, ppa.attribute31 project_attribute31, ppa.attribute32 project_attribute32, ppa.attribute33 project_attribute33, ppa.attribute34 project_attribute34, ppa.attribute35 project_attribute35, ppa.attribute36 project_attribute36, ppa.attribute37 project_attribute37, ppa.attribute38 project_attribute38, ppa.attribute39 project_attribute39, ppa.attribute40 project_attribute40, ppa.attribute41 project_attribute41, ppa.attribute42 project_attribute42, ppa.attribute43 project_attribute43, ppa.attribute44 project_attribute44, ppa.attribute45 project_attribute45, ppa.attribute46 project_attribute46, ppa.attribute47 project_attribute47, ppa.attribute48 project_attribute48, ppa.attribute49 project_attribute49, ppa.attribute50 project_attribute50, ppa.attribute1_number project_attribute1_number, ppa.attribute2_number project_attribute2_number, ppa.attribute3_number project_attribute3_number, ppa.attribute4_number project_attribute4_number, ppa.attribute5_number project_attribute5_number, ppa.attribute6_number project_attribute6_number, ppa.attribute7_number project_attribute7_number, ppa.attribute8_number project_attribute8_number, ppa.attribute9_number project_attribute9_number, ppa.attribute10_number project_attribute10_number, ppa.attribute11_number project_attribute11_number, ppa.attribute12_number project_attribute12_number, ppa.attribute13_number project_attribute13_number, ppa.attribute14_number project_attribute14_number, ppa.attribute15_number project_attribute15_number, ppa.attribute1_date project_attribute1_date, ppa.attribute2_date project_attribute2_date, ppa.attribute3_date project_attribute3_date, ppa.attribute4_date project_attribute4_date, ppa.attribute5_date project_attribute5_date, ppa.attribute6_date project_attribute6_date, ppa.attribute7_date project_attribute7_date, ppa.attribute8_date project_attribute8_date, ppa.attribute9_date project_attribute9_date, ppa.attribute10_date project_attribute10_date, ppa.attribute11_date project_attribute11_date, ppa.attribute12_date project_attribute12_date, ppa.attribute13_date project_attribute13_date, ppa.attribute14_date project_attribute14_date, ppa.attribute15_date project_attribute15_date, pt.attribute_category task_attribute_category, pt.attribute1 task_attribute1, pt.attribute2 task_attribute2, pt.attribute3 task_attribute3, pt.attribute4 task_attribute4, pt.attribute5 task_attribute5, pt.attribute6 task_attribute6, pt.attribute7 task_attribute7, pt.attribute8 task_attribute8, pt.attribute9 task_attribute9, pt.attribute10 task_attribute10, pt.attribute11 task_attribute11, pt.attribute12 task_attribute12, pt.attribute13 task_attribute13, pt.attribute14 task_attribute14, pt.attribute15 task_attribute15, ppa.carrying_out_organization_id project_expenditure_org_id, ppa.org_id project_owning_org_id FROM cst_inv_transactions cit, pjf_tasks_v pt, pjf_projects_all_vl ppa, pjf_exp_types_vl pet WHERE cit.pjc_project_id = ppa.project_id AND cit.pjc_task_id = pt.task_id AND cit.pjc_project_id IS NOT NULL AND cit.pjc_expenditure_type_id = pet.expenditure_type_id

SQL_Statement

SELECT

cit.pjc_project_id project_id,

cit.pjc_task_id task_id,

cit.pjc_expenditure_type_id expenditure_type_id,

cit.pjc_expenditure_item_date expenditure_item_date,

cit.pjc_organization_id expenditure_organization_id,

cit.pjc_work_type_id work_type_id,

cit.pjc_contract_id contract_id,

cit.pjc_contract_line_id contract_line_id,

cit.pjc_funding_allocation_id funding_allocation_id,

cit.pjc_billable_flag billable_flag,

cit.pjc_capitalizable_flag capitalizable_flag,

cit.pjc_context_category context_category,

cit.pjc_user_def_attribute1 user_def_attribute1,

cit.pjc_user_def_attribute2 user_def_attribute2,

cit.pjc_user_def_attribute3 user_def_attribute3,

cit.pjc_user_def_attribute4 user_def_attribute4,

cit.pjc_user_def_attribute5 user_def_attribute5,

cit.pjc_user_def_attribute6 user_def_attribute6,

cit.pjc_user_def_attribute7 user_def_attribute7,

cit.pjc_user_def_attribute8 user_def_attribute8,

cit.pjc_user_def_attribute9 user_def_attribute9,

cit.pjc_user_def_attribute10 user_def_attribute10,

cit.pjc_reserved_attribute1 reserved_attribute1,

cit.pjc_reserved_attribute2 reserved_attribute2,

cit.pjc_reserved_attribute3 reserved_attribute3,

cit.pjc_reserved_attribute4 reserved_attribute4,

cit.pjc_reserved_attribute5 reserved_attribute5,

cit.pjc_reserved_attribute6 reserved_attribute6,

cit.pjc_reserved_attribute7 reserved_attribute7,

cit.pjc_reserved_attribute8 reserved_attribute8,

cit.pjc_reserved_attribute9 reserved_attribute9,

cit.pjc_reserved_attribute10 reserved_attribute10,

cit.cst_inv_transaction_id cst_inv_transaction_id,

ppa.segment1 project_number,

ppa.name project_name,

pt.task_number task_number,

pt.task_name task_name,

pet.expenditure_type_name expenditure_type_name,

ppa.attribute_category project_attribute_category,

ppa.attribute1 project_attribute1,

ppa.attribute2 project_attribute2,

ppa.attribute3 project_attribute3,

ppa.attribute4 project_attribute4,

ppa.attribute5 project_attribute5,

ppa.attribute6 project_attribute6,

ppa.attribute7 project_attribute7,

ppa.attribute8 project_attribute8,

ppa.attribute9 project_attribute9,

ppa.attribute10 project_attribute10,

ppa.attribute11 project_attribute11,

ppa.attribute12 project_attribute12,

ppa.attribute13 project_attribute13,

ppa.attribute14 project_attribute14,

ppa.attribute15 project_attribute15,

ppa.attribute16 project_attribute16,

ppa.attribute17 project_attribute17,

ppa.attribute18 project_attribute18,

ppa.attribute19 project_attribute19,

ppa.attribute20 project_attribute20,

ppa.attribute21 project_attribute21,

ppa.attribute22 project_attribute22,

ppa.attribute23 project_attribute23,

ppa.attribute24 project_attribute24,

ppa.attribute25 project_attribute25,

ppa.attribute26 project_attribute26,

ppa.attribute27 project_attribute27,

ppa.attribute28 project_attribute28,

ppa.attribute29 project_attribute29,

ppa.attribute30 project_attribute30,

ppa.attribute31 project_attribute31,

ppa.attribute32 project_attribute32,

ppa.attribute33 project_attribute33,

ppa.attribute34 project_attribute34,

ppa.attribute35 project_attribute35,

ppa.attribute36 project_attribute36,

ppa.attribute37 project_attribute37,

ppa.attribute38 project_attribute38,

ppa.attribute39 project_attribute39,

ppa.attribute40 project_attribute40,

ppa.attribute41 project_attribute41,

ppa.attribute42 project_attribute42,

ppa.attribute43 project_attribute43,

ppa.attribute44 project_attribute44,

ppa.attribute45 project_attribute45,

ppa.attribute46 project_attribute46,

ppa.attribute47 project_attribute47,

ppa.attribute48 project_attribute48,

ppa.attribute49 project_attribute49,

ppa.attribute50 project_attribute50,

ppa.attribute1_number project_attribute1_number,

ppa.attribute2_number project_attribute2_number,

ppa.attribute3_number project_attribute3_number,

ppa.attribute4_number project_attribute4_number,

ppa.attribute5_number project_attribute5_number,

ppa.attribute6_number project_attribute6_number,

ppa.attribute7_number project_attribute7_number,

ppa.attribute8_number project_attribute8_number,

ppa.attribute9_number project_attribute9_number,

ppa.attribute10_number project_attribute10_number,

ppa.attribute11_number project_attribute11_number,

ppa.attribute12_number project_attribute12_number,

ppa.attribute13_number project_attribute13_number,

ppa.attribute14_number project_attribute14_number,

ppa.attribute15_number project_attribute15_number,

ppa.attribute1_date project_attribute1_date,

ppa.attribute2_date project_attribute2_date,

ppa.attribute3_date project_attribute3_date,

ppa.attribute4_date project_attribute4_date,

ppa.attribute5_date project_attribute5_date,

ppa.attribute6_date project_attribute6_date,

ppa.attribute7_date project_attribute7_date,

ppa.attribute8_date project_attribute8_date,

ppa.attribute9_date project_attribute9_date,

ppa.attribute10_date project_attribute10_date,

ppa.attribute11_date project_attribute11_date,

ppa.attribute12_date project_attribute12_date,

ppa.attribute13_date project_attribute13_date,

ppa.attribute14_date project_attribute14_date,

ppa.attribute15_date project_attribute15_date,

pt.attribute_category task_attribute_category,

pt.attribute1 task_attribute1,

pt.attribute2 task_attribute2,

pt.attribute3 task_attribute3,

pt.attribute4 task_attribute4,

pt.attribute5 task_attribute5,

pt.attribute6 task_attribute6,

pt.attribute7 task_attribute7,

pt.attribute8 task_attribute8,

pt.attribute9 task_attribute9,

pt.attribute10 task_attribute10,

pt.attribute11 task_attribute11,

pt.attribute12 task_attribute12,

pt.attribute13 task_attribute13,

pt.attribute14 task_attribute14,

pt.attribute15 task_attribute15,

ppa.carrying_out_organization_id project_expenditure_org_id,

ppa.org_id project_owning_org_id

FROM

cst_inv_transactions cit,

pjf_tasks_v pt,

pjf_projects_all_vl ppa,

pjf_exp_types_vl pet

WHERE

cit.pjc_project_id = ppa.project_id

AND cit.pjc_task_id = pt.task_id

AND cit.pjc_project_id IS NOT NULL

AND cit.pjc_expenditure_type_id = pet.expenditure_type_id