PJC_XLA_COST

Details

Schema: FUSION
Object owner: PJC
Object type: VIEW

Columns

Name
EXPENDITURE_ITEM_ID PROJECT_ID PROJECT_NUMBER TASK_ID TASK_NUMBER EXPENDITURE_TYPE_ID EXPENDITURE_TYPE EXPENDITURE_TYPE_CLASS EXPENDITURE_CATEGORY_ID EXPENDITURE_CATEGORY EXPENDITURE_ITEM_DATE EXP_ORGANIZATION_NAME NON_LABOR_RESOURCE_ID NON_LABOR_RESOURCE TRANSACTION_SOURCE DOCUMENT_NAME DOCUMENT_ENTRY_NAME

Name

EXPENDITURE_ITEM_ID

PROJECT_ID

PROJECT_NUMBER

TASK_ID

TASK_NUMBER

EXPENDITURE_TYPE_ID

EXPENDITURE_TYPE

EXPENDITURE_TYPE_CLASS

EXPENDITURE_CATEGORY_ID

EXPENDITURE_CATEGORY

EXPENDITURE_ITEM_DATE

EXP_ORGANIZATION_NAME

NON_LABOR_RESOURCE_ID

NON_LABOR_RESOURCE

TRANSACTION_SOURCE

DOCUMENT_NAME

DOCUMENT_ENTRY_NAME

Query

SQL_Statement
SELECT EXP.expenditure_item_id, pp.project_id , pp.segment1 PROJECT_NUMBER, pt.proj_element_id task_id, pt.element_number TASK_NUMBER, et.expenditure_type_id , et.expenditure_type_name EXPENDITURE_TYPE, /MLS Src/ syslink.meaning expenditure_type_class , et.expenditure_category_id , exp_cat.expenditure_category_name EXPENDITURE_CATEGORY, /MLS Src/ EXP.expenditure_item_date , HR_ORG.name EXP_ORGANIZATION_NAME, /MLS source/ EXP.non_labor_resource_id, non_lab_res.nlr_name non_labor_resource, /MLS Src/ TXN_SRC.TRANSACTION_SOURCE Transaction_source, /MLS Src/ TXN_DOC.DOCUMENT_NAME Document_name , /MLS Src/ TXN_DOC_ENTRY.DOC_ENTRY_NAME Document_entry_Name /MLS Src/ FROM pjc_exp_items_all EXP , pjf_proj_elements_b pt , pjf_projects_all_b pp , pjf_exp_types_vl et , pjf_system_linkages_vl syslink, pjf_exp_categories_vl exp_cat, PJF_NON_LABOR_RES_VL non_lab_res, PJF_TXN_SOURCES_VL TXN_SRC, pjf_txn_document_vl TXN_DOC, PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY, HR_ALL_ORGANIZATION_UNITS_VL HR_ORG WHERE EXP.project_id = pt.project_id AND EXP.project_id = pp.project_id AND EXP.task_id = pt.proj_element_id AND EXP.expenditure_type_id = et.expenditure_type_id AND EXP.system_linkage_function = syslink.FUNCTION and et.expenditure_category_id = exp_cat.expenditure_category_id and exp.non_labor_resource_id = non_lab_res.non_labor_resource_id(+) AND EXP.TRANSACTION_SOURCE_ID =TXN_SRC.TRANSACTION_SOURCE_ID AND TXN_DOC.DOCUMENT_ID = EXP.DOCUMENT_ID AND TXN_DOC_ENTRY.DOC_ENTRY_ID = EXP.DOC_ENTRY_ID and EXP.Expenditure_organization_id = HR_ORG.ORGANIZATION_ID

SQL_Statement

SELECT EXP.expenditure_item_id,

pp.project_id ,

pp.segment1 PROJECT_NUMBER,

pt.proj_element_id task_id,

pt.element_number TASK_NUMBER,

et.expenditure_type_id ,

et.expenditure_type_name EXPENDITURE_TYPE, /*MLS Src*/

syslink.meaning expenditure_type_class ,

et.expenditure_category_id ,

exp_cat.expenditure_category_name EXPENDITURE_CATEGORY, /*MLS Src*/

EXP.expenditure_item_date ,

HR_ORG.name EXP_ORGANIZATION_NAME, /*MLS source*/

EXP.non_labor_resource_id,

non_lab_res.nlr_name non_labor_resource, /*MLS Src*/

TXN_SRC.TRANSACTION_SOURCE Transaction_source, /*MLS Src*/

TXN_DOC.DOCUMENT_NAME Document_name , /*MLS Src*/

TXN_DOC_ENTRY.DOC_ENTRY_NAME Document_entry_Name /*MLS Src*/

FROM pjc_exp_items_all EXP ,

pjf_proj_elements_b pt ,

pjf_projects_all_b pp ,

pjf_exp_types_vl et ,

pjf_system_linkages_vl syslink,

pjf_exp_categories_vl exp_cat,

PJF_NON_LABOR_RES_VL non_lab_res,

PJF_TXN_SOURCES_VL TXN_SRC,

pjf_txn_document_vl TXN_DOC,

PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY,

HR_ALL_ORGANIZATION_UNITS_VL HR_ORG

WHERE EXP.project_id = pt.project_id

AND EXP.project_id = pp.project_id

AND EXP.task_id = pt.proj_element_id

AND EXP.expenditure_type_id = et.expenditure_type_id

AND EXP.system_linkage_function = syslink.FUNCTION

and et.expenditure_category_id = exp_cat.expenditure_category_id

and exp.non_labor_resource_id = non_lab_res.non_labor_resource_id(+)

AND EXP.TRANSACTION_SOURCE_ID =TXN_SRC.TRANSACTION_SOURCE_ID

AND TXN_DOC.DOCUMENT_ID = EXP.DOCUMENT_ID

AND TXN_DOC_ENTRY.DOC_ENTRY_ID = EXP.DOC_ENTRY_ID

and EXP.Expenditure_organization_id = HR_ORG.ORGANIZATION_ID