1. Tables and Views for Project Management
  2. PJC_XLA_XFR_PROJ_REF_V

PJC_XLA_XFR_PROJ_REF_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

XFR_PROJECT_ID

XFR_PROJECT_NAME

XFR_PROJ_TYPE_ID

XFR_PROJ_TYPE

XFR_PROJECT_NUMBER

XFR_PROJ_ORGANIZATION_ID

XFR_PROJ_ORGANIZATION_NAME

XFR_PROJ_BURDEN_COST_FLAG

XFR_PROJ_BURDEN_DISPLAY_METHOD

XFR_PROJ_ORG_COMPANY

XFR_PROJ_ORG_COST_CENTER

PROJECT_BUSINESS_UNIT_ID

PROJECT_BUSINESS_UNIT_NAME

XFR_PROJ_OU_COMPANY

XFR_PROJ_OU_COST_CENTER

XFR_PROJ_ATTRIBUTE_CATEGORY

XFR_PROJ_ATTRIBUTE1

XFR_PROJ_ATTRIBUTE2

XFR_PROJ_ATTRIBUTE3

XFR_PROJ_ATTRIBUTE4

XFR_PROJ_ATTRIBUTE5

XFR_PROJ_ATTRIBUTE6

XFR_PROJ_ATTRIBUTE7

XFR_PROJ_ATTRIBUTE8

XFR_PROJ_ATTRIBUTE9

XFR_PROJ_ATTRIBUTE10

XFR_PROJ_TYPE_ATTR_CATEGORY

XFR_PROJ_TYPE_ATTRIBUTE1

XFR_PROJ_TYPE_ATTRIBUTE2

XFR_PROJ_TYPE_ATTRIBUTE3

XFR_PROJ_TYPE_ATTRIBUTE4

XFR_PROJ_TYPE_ATTRIBUTE5

XFR_PROJ_TYPE_ATTRIBUTE6

XFR_PROJ_TYPE_ATTRIBUTE7

XFR_PROJ_TYPE_ATTRIBUTE8

XFR_PROJ_TYPE_ATTRIBUTE9

XFR_PROJ_TYPE_ATTRIBUTE10

PROJECT_BILLABLE_FLAG

PROJECT_CAPITALIZABLE_FLAG

BURDEN_ACCOUNT_FLAG

XFR_PROJECT_LEGAL_ENTITY_ID

XFR_PROJECT_LEGAL_ENTITY_NAME

SPONSORED_PROJECT

Query

SQL_Statement

SELECT p.project_id xfr_Project_ID,

p.project_id xfr_Project_Name ,

/*MLS Src*/

pt.project_type_id xfr_proj_type_id ,

pt.project_type_id Xfr_Proj_Type,

/*MLS Src*/

p.segment1 xfr_Project_Number ,

p.carrying_out_organization_id xfr_Proj_Organization_ID ,

p.carrying_out_organization_id xfr_Proj_Organization_name ,

pt.burden_cost_flag xfr_Proj_Burden_Cost_Flag ,

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

/* pt.burden_amt_display_method xfr_Proj_burden_display_Method, */

pjc_accounting_pvt.get_company_info(p.carrying_out_organization_id) xfr_proj_org_company ,

pjc_accounting_pvt.get_costcenter_info(p.carrying_out_organization_id) xfr_proj_org_cost_center ,

p.org_id project_business_unit_id ,

p.org_id project_business_unit_name,

pjc_accounting_pvt.get_company_info(p.org_id) xfr_proj_ou_company ,

pjc_accounting_pvt.get_costcenter_info(p.org_id) xfr_proj_ou_cost_center ,

p.attribute_category xfr_Proj_Attribute_category ,

p.attribute1 xfr_proj_attribute1 ,

p.attribute2 xfr_proj_attribute2 ,

p.attribute3 xfr_proj_attribute3 ,

p.attribute4 xfr_proj_attribute4 ,

p.attribute5 xfr_proj_attribute5 ,

p.attribute6 xfr_proj_attribute6 ,

p.attribute7 xfr_proj_attribute7 ,

p.attribute8 xfr_proj_attribute8 ,

p.attribute9 xfr_proj_attribute9 ,

p.attribute10 xfr_proj_attribute10 ,

pt.attribute_category xfr_Proj_Type_Attr_Category ,

pt.attribute1 xfr_proj_type_attribute1 ,

pt.attribute2 xfr_proj_type_attribute2 ,

pt.attribute3 xfr_proj_type_attribute3 ,

pt.attribute4 xfr_proj_type_attribute4 ,

pt.attribute5 xfr_proj_type_attribute5 ,

pt.attribute6 xfr_proj_type_attribute6 ,

pt.attribute7 xfr_proj_type_attribute7 ,

pt.attribute8 xfr_proj_type_attribute8 ,

pt.attribute9 xfr_proj_type_attribute9 ,

pt.attribute10 xfr_proj_type_attribute10,

PT.ENABLE_BILLING_FLAG project_billable_flag,

PT.ENABLE_CAPITALIZATION_FLAG project_capitalizable_flag,

PT.burden_account_flag,

p.legal_entity_id xfr_project_legal_entity_id,

p.legal_entity_id xfr_project_legal_entity_name,

pt.SPONSORED_FLAG SPONSORED_PROJECT

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