1. Tables and Views for Project Management
  2. PJB_XLA_EXP_REF_V

PJB_XLA_EXP_REF_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

EXPENDITURE_ITEM_ID

EXPENDITURE_TYPE

EXPENDITURE_TYPE_ID

EXPENDITURE_ORGANIZATION_ID

EXP_ORGANIZATION_NAME

EXP_ORG_COMPANY

EXP_ORG_COST_CENTER

OVERRIDE_TO_ORG_ID

OVERRIDE_TO_ORG_NAME

EXPENDITURE_ITEM_DATE

ORIG_EXP_ITEM_TXN_REFERENCE

EXPENDITURE_BU_ID

EXPENDITURE_BU_NAME

EXP_BU_COMPANY

EXP_BU_COST_CENTER

PERSON_ID

NON_LABOR_RESOURCE_ID

NON_LABOR_RESOURCE

NL_RES_ORGANIZATION_ID

NL_RES_ORGANIZATION_NAME

NLR_ORG_COMPANY

NLR_ORG_COST_CENTER

INVENTORY_ITEM_ID

IC_BILLABLE_FLAG

CAPITALIZABLE_FLAG

WORK_TYPE_ID

WORK_TYPE_NAME

PEI_ATTRIBUTE_CATEGORY

PEI_ATTRIBUTE1

PEI_ATTRIBUTE2

PEI_ATTRIBUTE3

PEI_ATTRIBUTE4

PEI_ATTRIBUTE5

PEI_ATTRIBUTE6

PEI_ATTRIBUTE7

PEI_ATTRIBUTE8

PEI_ATTRIBUTE9

PEI_ATTRIBUTE10

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

VENDOR_ID

PO_LINE_ID

EXP_ITEM_CREATION_DATE

EXPENDITURE_BATCH

USER_EXPENDITURE_BATCH

EXP_ITEM_LAST_UPDATED_BY

EXP_ITEM_CREATED_BY

EXP_ITEM_LAST_UPDATED_DATE

EXPENDITURE_COMMENT

PAY_ELEMENT_TYPE

CONTRACT_ID

FUNDING_SOURCE_ID

Query

SQL_Statement

SELECT

ExpItem.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID,

ExpItem.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE,

ExpItem.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID,

ExpItem.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID,

ExpItem.EXPENDITURE_ORGANIZATION_ID EXP_ORGANIZATION_NAME,

pjc_accounting_pvt.get_company_info(ExpItem.EXPENDITURE_ORGANIZATION_ID) EXP_ORG_COMPANY,

pjc_accounting_pvt.get_costcenter_info(ExpItem.EXPENDITURE_ORGANIZATION_ID) EXP_ORG_COST_CENTER,

ExpItem.OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORG_ID,

ExpItem.OVERRIDE_TO_ORGANIZATION_ID OVERRIDE_TO_ORG_NAME,

ExpItem.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, ExpItem.ORIG_TRANSACTION_REFERENCE ORIG_EXP_ITEM_TXN_REFERENCE,

ExpItem.ORG_ID EXPENDITURE_BU_ID,

ExpItem.ORG_ID EXPENDITURE_BU_NAME,

pjc_accounting_pvt.get_company_info(ExpItem.ORG_ID) EXP_BU_COMPANY,

pjc_accounting_pvt.get_costcenter_info(ExpItem.ORG_ID) EXP_BU_COST_CENTER,

ExpItem.INCURRED_BY_PERSON_ID PERSON_ID,

ExpItem.NON_LABOR_RESOURCE_ID NON_LABOR_RESOURCE_ID,

ExpItem.NON_LABOR_RESOURCE_ID NON_LABOR_RESOURCE,

ExpItem.NON_LABOR_RESOURCE_ORG_ID NL_RES_ORGANIZATION_ID,

ExpItem.NON_LABOR_RESOURCE_ORG_ID NL_RES_ORGANIZATION_NAME,

pjc_accounting_pvt.get_company_info(ExpItem.NON_LABOR_RESOURCE_ORG_ID) NLR_ORG_COMPANY,

pjc_accounting_pvt.get_costcenter_info(ExpItem.NON_LABOR_RESOURCE_ORG_ID) NLR_ORG_COST_CENTER,

ExpItem.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

ExpItem.IC_BILLABLE_FLAG IC_BILLABLE_FLAG,

ExpItem.CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG,

ExpItem.WORK_TYPE_ID WORK_TYPE_ID,

ExpItem.WORK_TYPE_ID WORK_TYPE_NAME,

ExpItem.ATTRIBUTE_CATEGORY PEI_ATTRIBUTE_CATEGORY,

ExpItem.ATTRIBUTE1 PEI_ATTRIBUTE1,

ExpItem.ATTRIBUTE2 PEI_ATTRIBUTE2,

ExpItem.ATTRIBUTE3 PEI_ATTRIBUTE3,

ExpItem.ATTRIBUTE4 PEI_ATTRIBUTE4,

ExpItem.ATTRIBUTE5 PEI_ATTRIBUTE5,

ExpItem.ATTRIBUTE6 PEI_ATTRIBUTE6,

ExpItem.ATTRIBUTE7 PEI_ATTRIBUTE7,

ExpItem.ATTRIBUTE8 PEI_ATTRIBUTE8,

ExpItem.ATTRIBUTE9 PEI_ATTRIBUTE9,

ExpItem.ATTRIBUTE10 PEI_ATTRIBUTE10,

ExpItem.CONTEXT_CATEGORY CONTEXT_CATEGORY,

ExpItem.USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE1,

ExpItem.USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE2,

ExpItem.USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE3,

ExpItem.USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE4,

ExpItem.USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE5,

ExpItem.USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE6,

ExpItem.USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE7,

ExpItem.USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE8,

ExpItem.USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE9,

ExpItem.USER_DEF_ATTRIBUTE10 USER_DEF_ATTRIBUTE10,

ExpItem.VENDOR_ID VENDOR_ID,

ExpItem.PARENT_LINE_NUMBER PO_LINE_ID,

trunc(ExpItem.CREATION_DATE) EXP_ITEM_CREATION_DATE,

EiGroup.EXPENDITURE_GROUP EXPENDITURE_BATCH,

EiGroup.USER_BATCH_NAME USER_EXPENDITURE_BATCH,

ExpItem.LAST_UPDATED_BY EXP_ITEM_LAST_UPDATED_BY,

ExpItem.CREATED_BY EXP_ITEM_CREATED_BY,

trunc(ExpItem.LAST_UPDATE_DATE) EXP_ITEM_LAST_UPDATED_DATE,

ExpComment.Expenditure_Comment EXPENDITURE_COMMENT,

ExpItem.REFERENCE_ID3 PAY_ELEMENT_TYPE,

ExpItem.Contract_Id CONTRACT_ID,

ExpItem.RESERVED_ATTRIBUTE1 FUNDING_SOURCE_ID

FROM

PJC_EXP_ITEMS_ALL ExpItem,PJC_EXP_GROUPS_ALL EiGroup,

PJC_EXP_COMMENTS ExpComment

WHERE EiGroup.EXP_GROUP_ID = ExpItem.EXP_GROUP_ID

AND ExpItem.Expenditure_Item_Id=ExpComment.Expenditure_Item_id(+)