PJC_XLA_CROSSCHARGE

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 PROVIDER_ORGANIZATION_ID CROSS_CHARGE_CODE 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

PROVIDER_ORGANIZATION_ID

CROSS_CHARGE_CODE

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, EXP.cc_prvdr_organization_id PROVIDER_ORGANIZATION_ID , EXP.cc_cross_charge_code CROSS_CHARGE_CODE , 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, HR_ALL_ORGANIZATION_UNITS_VL HR_ORG, PJF_TXN_SOURCES_VL TXN_SRC, pjf_txn_document_vl TXN_DOC, PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY 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.Expenditure_organization_id = HR_ORG.ORGANIZATION_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

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,

EXP.cc_prvdr_organization_id PROVIDER_ORGANIZATION_ID ,

EXP.cc_cross_charge_code CROSS_CHARGE_CODE ,

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,

HR_ALL_ORGANIZATION_UNITS_VL HR_ORG,

PJF_TXN_SOURCES_VL TXN_SRC,

pjf_txn_document_vl TXN_DOC,

PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY

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.Expenditure_organization_id = HR_ORG.ORGANIZATION_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