PJC_XLA_PROJECT_REF

Details

Schema: FUSION
Object owner: PJC
Object type: VIEW

Columns

Name
PROJECT_ID PROJECT_NAME PROJECT_TYPE_ID PROJECT_TYPE PROJECT_NUMBER PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_NAME PROJ_BURDEN_COST_FLAG PROJ_BURDEN_DISPLAY_METHOD PROJECT_ORG_COMPANY PROJECT_ORG_COST_CENTER PROJECT_BUSINESS_UNIT_ID PROJECT_BUSINESS_UNIT_NAME PROJECT_UNIT_ID PROJECT_UNIT PROJECT_BU_COMPANY PROJECT_BU_COST_CENTER PROJECT_ATTRIBUTE_CATEGORY PROJECT_NULL_CCID PROJECT_ATTRIBUTE1 PROJECT_ATTRIBUTE2 PROJECT_ATTRIBUTE3 PROJECT_ATTRIBUTE4 PROJECT_ATTRIBUTE5 PROJECT_ATTRIBUTE6 PROJECT_ATTRIBUTE7 PROJECT_ATTRIBUTE8 PROJECT_ATTRIBUTE9 PROJECT_ATTRIBUTE10 PROJ_TYPE_ATTRIBUTE_CATEGORY PROJ_TYPE_ATTRIBUTE1 PROJ_TYPE_ATTRIBUTE2 PROJ_TYPE_ATTRIBUTE3 PROJ_TYPE_ATTRIBUTE4 PROJ_TYPE_ATTRIBUTE5 PROJ_TYPE_ATTRIBUTE6 PROJ_TYPE_ATTRIBUTE7 PROJ_TYPE_ATTRIBUTE8 PROJ_TYPE_ATTRIBUTE9 PROJ_TYPE_ATTRIBUTE10 PROJECT_BILLABLE_FLAG PROJECT_CAPITALIZABLE_FLAG BURDEN_ACCOUNT_FLAG PROJECT_LEGAL_ENTITY_ID PROJECT_LEGAL_ENTITY_NAME SPONSORED_PROJECT 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 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

Name

PROJECT_ID

PROJECT_NAME

PROJECT_TYPE_ID

PROJECT_TYPE

PROJECT_NUMBER

PROJECT_ORGANIZATION_ID

PROJECT_ORGANIZATION_NAME

PROJ_BURDEN_COST_FLAG

PROJ_BURDEN_DISPLAY_METHOD

PROJECT_ORG_COMPANY

PROJECT_ORG_COST_CENTER

PROJECT_BUSINESS_UNIT_ID

PROJECT_BUSINESS_UNIT_NAME

PROJECT_UNIT_ID

PROJECT_UNIT

PROJECT_BU_COMPANY

PROJECT_BU_COST_CENTER

PROJECT_ATTRIBUTE_CATEGORY

PROJECT_NULL_CCID

PROJECT_ATTRIBUTE1

PROJECT_ATTRIBUTE2

PROJECT_ATTRIBUTE3

PROJECT_ATTRIBUTE4

PROJECT_ATTRIBUTE5

PROJECT_ATTRIBUTE6

PROJECT_ATTRIBUTE7

PROJECT_ATTRIBUTE8

PROJECT_ATTRIBUTE9

PROJECT_ATTRIBUTE10

PROJ_TYPE_ATTRIBUTE_CATEGORY

PROJ_TYPE_ATTRIBUTE1

PROJ_TYPE_ATTRIBUTE2

PROJ_TYPE_ATTRIBUTE3

PROJ_TYPE_ATTRIBUTE4

PROJ_TYPE_ATTRIBUTE5

PROJ_TYPE_ATTRIBUTE6

PROJ_TYPE_ATTRIBUTE7

PROJ_TYPE_ATTRIBUTE8

PROJ_TYPE_ATTRIBUTE9

PROJ_TYPE_ATTRIBUTE10

PROJECT_BILLABLE_FLAG

PROJECT_CAPITALIZABLE_FLAG

BURDEN_ACCOUNT_FLAG

PROJECT_LEGAL_ENTITY_ID

PROJECT_LEGAL_ENTITY_NAME

SPONSORED_PROJECT

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

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

Query

SQL_Statement
SELECT p.project_id , p.project_id project_name, pt.project_type_id , pt.project_type_id project_type, p.segment1 project_number , p.carrying_out_organization_id project_organization_id , p.carrying_out_organization_id project_organization_name , pt.burden_cost_flag proj_burden_cost_flag, DECODE(NVL(pt.burden_cost_flag, 'N'), 'Y', NVL(pt.burden_amt_display_method, 'S'), 'N') proj_burden_display_method, pjc_accounting_pvt.get_company_info(p.carrying_out_organization_id) project_org_company , pjc_accounting_pvt.get_costcenter_info(p.carrying_out_organization_id) project_org_cost_center , p.org_id project_business_unit_id , p.org_id project_business_unit_name , p.project_unit_id project_unit_id , p.project_unit_id project_unit, pjc_accounting_pvt.get_company_info(p.org_id) project_BU_company , pjc_accounting_pvt.get_costcenter_info(p.org_id) project_BU_cost_center , p.attribute_category project_attribute_category , to_number(NULL) project_null_ccid , p.attribute1 project_attribute1 , p.attribute2 project_attribute2 , p.attribute3 project_attribute3 , p.attribute4 project_attribute4 , p.attribute5 project_attribute5 , p.attribute6 project_attribute6 , p.attribute7 project_attribute7 , p.attribute8 project_attribute8 , p.attribute9 project_attribute9 , p.attribute10 project_attribute10 , pt.attribute_category proj_type_attribute_category , pt.attribute1 proj_type_attribute1 , pt.attribute2 proj_type_attribute2 , pt.attribute3 proj_type_attribute3 , pt.attribute4 proj_type_attribute4 , pt.attribute5 proj_type_attribute5 , pt.attribute6 proj_type_attribute6 , pt.attribute7 proj_type_attribute7 , pt.attribute8 proj_type_attribute8 , pt.attribute9 proj_type_attribute9 , pt.attribute10 proj_type_attribute10 , /source Create Expenditure Items for Each Burden Cost Component on a Separate Project./ /* pt.burden_cost_journal_flag, /new source Create Burden Cost Accounting Journals./ /* pt.total_burdened_journal_flag, /* new source Create Total Burdened Cost Accounting Journals.*/ PT.ENABLE_BILLING_FLAG project_billable_flag, PT.ENABLE_CAPITALIZATION_FLAG project_capitalizable_flag, PT.burden_account_flag, p.legal_entity_id project_legal_entity_id, p.legal_entity_id project_legal_entity_name, pt.SPONSORED_FLAG SPONSORED_PROJECT, p.attribute1_number project_attribute1_number, p.attribute2_number project_attribute2_number, p.attribute3_number project_attribute3_number, p.attribute4_number project_attribute4_number, p.attribute5_number project_attribute5_number, p.attribute6_number project_attribute6_number, p.attribute7_number project_attribute7_number, p.attribute8_number project_attribute8_number, p.attribute9_number project_attribute9_number, p.attribute10_number project_attribute10_number, p.attribute11_number project_attribute11_number, p.attribute12_number project_attribute12_number, p.attribute13_number project_attribute13_number, p.attribute14_number project_attribute14_number, p.attribute15_number project_attribute15_number, p.attribute1_date project_attribute1_date, p.attribute2_date project_attribute2_date, p.attribute3_date project_attribute3_date, p.attribute4_date project_attribute4_date, p.attribute5_date project_attribute5_date, p.attribute6_date project_attribute6_date, p.attribute7_date project_attribute7_date, p.attribute8_date project_attribute8_date, p.attribute9_date project_attribute9_date, p.attribute10_date project_attribute10_date, p.attribute11_date project_attribute11_date, p.attribute12_date project_attribute12_date, p.attribute13_date project_attribute13_date, p.attribute14_date project_attribute14_date, p.attribute15_date project_attribute15_date, p.attribute11 project_attribute11, p.attribute12 project_attribute12, p.attribute13 project_attribute13, p.attribute14 project_attribute14, p.attribute15 project_attribute15, p.attribute16 project_attribute16, p.attribute17 project_attribute17, p.attribute18 project_attribute18, p.attribute19 project_attribute19, p.attribute20 project_attribute20, p.attribute21 project_attribute21, p.attribute22 project_attribute22, p.attribute23 project_attribute23, p.attribute24 project_attribute24, p.attribute25 project_attribute25, p.attribute26 project_attribute26, p.attribute27 project_attribute27, p.attribute28 project_attribute28, p.attribute29 project_attribute29, p.attribute30 project_attribute30, p.attribute31 project_attribute31, p.attribute32 project_attribute32, p.attribute33 project_attribute33, p.attribute34 project_attribute34, p.attribute35 project_attribute35, p.attribute36 project_attribute36, p.attribute37 project_attribute37, p.attribute38 project_attribute38, p.attribute39 project_attribute39, p.attribute40 project_attribute40, p.attribute41 project_attribute41, p.attribute42 project_attribute42, p.attribute43 project_attribute43, p.attribute44 project_attribute44, p.attribute45 project_attribute45, p.attribute46 project_attribute46, p.attribute47 project_attribute47, p.attribute48 project_attribute48, p.attribute49 project_attribute49, p.attribute50 project_attribute50 FROM pjf_projects_all_b p , pjf_project_types_b pt WHERE pt.project_type_id = p.project_type_id AND p.project_category = 'FIN_EXEC' AND p.org_id <> -1

SQL_Statement

SELECT p.project_id ,

p.project_id project_name,

pt.project_type_id ,

pt.project_type_id project_type,

p.segment1 project_number ,

p.carrying_out_organization_id project_organization_id ,

p.carrying_out_organization_id project_organization_name ,

pt.burden_cost_flag proj_burden_cost_flag,

DECODE(NVL(pt.burden_cost_flag, 'N'), 'Y', NVL(pt.burden_amt_display_method, 'S'), 'N') proj_burden_display_method,

pjc_accounting_pvt.get_company_info(p.carrying_out_organization_id) project_org_company ,

pjc_accounting_pvt.get_costcenter_info(p.carrying_out_organization_id) project_org_cost_center ,

p.org_id project_business_unit_id ,

p.org_id project_business_unit_name ,

p.project_unit_id project_unit_id ,

p.project_unit_id project_unit,

pjc_accounting_pvt.get_company_info(p.org_id) project_BU_company ,

pjc_accounting_pvt.get_costcenter_info(p.org_id) project_BU_cost_center ,

p.attribute_category project_attribute_category ,

to_number(NULL) project_null_ccid ,

p.attribute1 project_attribute1 ,

p.attribute2 project_attribute2 ,

p.attribute3 project_attribute3 ,

p.attribute4 project_attribute4 ,

p.attribute5 project_attribute5 ,

p.attribute6 project_attribute6 ,

p.attribute7 project_attribute7 ,

p.attribute8 project_attribute8 ,

p.attribute9 project_attribute9 ,

p.attribute10 project_attribute10 ,

pt.attribute_category proj_type_attribute_category ,

pt.attribute1 proj_type_attribute1 ,

pt.attribute2 proj_type_attribute2 ,

pt.attribute3 proj_type_attribute3 ,

pt.attribute4 proj_type_attribute4 ,

pt.attribute5 proj_type_attribute5 ,

pt.attribute6 proj_type_attribute6 ,

pt.attribute7 proj_type_attribute7 ,

pt.attribute8 proj_type_attribute8 ,

pt.attribute9 proj_type_attribute9 ,

pt.attribute10 proj_type_attribute10 ,

/*source Create Expenditure Items for Each Burden Cost Component on a Separate Project.*/

/* pt.burden_cost_journal_flag, /*new source Create Burden Cost Accounting Journals.*/

/* pt.total_burdened_journal_flag, /* new source Create Total Burdened Cost Accounting Journals.*/

PT.ENABLE_BILLING_FLAG project_billable_flag,

PT.ENABLE_CAPITALIZATION_FLAG project_capitalizable_flag,

PT.burden_account_flag,

p.legal_entity_id project_legal_entity_id,

p.legal_entity_id project_legal_entity_name,

pt.SPONSORED_FLAG SPONSORED_PROJECT,

p.attribute1_number project_attribute1_number,

p.attribute2_number project_attribute2_number,

p.attribute3_number project_attribute3_number,

p.attribute4_number project_attribute4_number,

p.attribute5_number project_attribute5_number,

p.attribute6_number project_attribute6_number,

p.attribute7_number project_attribute7_number,

p.attribute8_number project_attribute8_number,

p.attribute9_number project_attribute9_number,

p.attribute10_number project_attribute10_number,

p.attribute11_number project_attribute11_number,

p.attribute12_number project_attribute12_number,

p.attribute13_number project_attribute13_number,

p.attribute14_number project_attribute14_number,

p.attribute15_number project_attribute15_number,

p.attribute1_date project_attribute1_date,

p.attribute2_date project_attribute2_date,

p.attribute3_date project_attribute3_date,

p.attribute4_date project_attribute4_date,

p.attribute5_date project_attribute5_date,

p.attribute6_date project_attribute6_date,

p.attribute7_date project_attribute7_date,

p.attribute8_date project_attribute8_date,

p.attribute9_date project_attribute9_date,

p.attribute10_date project_attribute10_date,

p.attribute11_date project_attribute11_date,

p.attribute12_date project_attribute12_date,

p.attribute13_date project_attribute13_date,

p.attribute14_date project_attribute14_date,

p.attribute15_date project_attribute15_date,

p.attribute11 project_attribute11,

p.attribute12 project_attribute12,

p.attribute13 project_attribute13,

p.attribute14 project_attribute14,

p.attribute15 project_attribute15,

p.attribute16 project_attribute16,

p.attribute17 project_attribute17,

p.attribute18 project_attribute18,

p.attribute19 project_attribute19,

p.attribute20 project_attribute20,

p.attribute21 project_attribute21,

p.attribute22 project_attribute22,

p.attribute23 project_attribute23,

p.attribute24 project_attribute24,

p.attribute25 project_attribute25,

p.attribute26 project_attribute26,

p.attribute27 project_attribute27,

p.attribute28 project_attribute28,

p.attribute29 project_attribute29,

p.attribute30 project_attribute30,

p.attribute31 project_attribute31,

p.attribute32 project_attribute32,

p.attribute33 project_attribute33,

p.attribute34 project_attribute34,

p.attribute35 project_attribute35,

p.attribute36 project_attribute36,

p.attribute37 project_attribute37,

p.attribute38 project_attribute38,

p.attribute39 project_attribute39,

p.attribute40 project_attribute40,

p.attribute41 project_attribute41,

p.attribute42 project_attribute42,

p.attribute43 project_attribute43,

p.attribute44 project_attribute44,

p.attribute45 project_attribute45,

p.attribute46 project_attribute46,

p.attribute47 project_attribute47,

p.attribute48 project_attribute48,

p.attribute49 project_attribute49,

p.attribute50 project_attribute50

FROM pjf_projects_all_b p ,

pjf_project_types_b pt

WHERE pt.project_type_id = p.project_type_id

AND p.project_category = 'FIN_EXEC'

AND p.org_id <> -1