View: PA_PROJ_EXPEND_VIEW

Product:	PA - Projects
Description:	Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usage
Implementation/DBA Data:	APPS.PA_PROJ_EXPEND_VIEW

View Text

SELECT EI.EXPENDITURE_ITEM_ID
, P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, (SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_CODE = EI.BILL_HOLD_FLAG
AND LOOKUP_TYPE = 'BILLING HOLD')
, EI.BILL_HOLD_FLAG
, PER.FULL_NAME
, NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, E.INCURRED_BY_PERSON_ID
, VEND.VENDOR_ID
, VEND.SEGMENT1
, VEND.VENDOR_NAME
, NVL(PER.FULL_NAME
, VEND.VENDOR_NAME)
, NVL(NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, VEND.SEGMENT1)
, PER.PERSON_ID
, E.INCURRED_BY_ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID
, NVL(PA_EXPENDITURES_UTILS.GETORGTLNAME(EI.OVERRIDE_TO_ORGANIZATION_ID)
, PA_EXPENDITURES_UTILS.GETORGTLNAME(E.INCURRED_BY_ORGANIZATION_ID))
, NVL(EI.BILL_JOB_ID
, ASG1.JOB_ID)
, NVL(EI.BILL_JOB_BILLING_TITLE
, JOB.NAME)
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'USG'
, EI.NON_LABOR_RESOURCE||'-'||PA_EXPENDITURES_UTILS.GETORGTLNAME(EI.ORGANIZATION_ID)
, 'VI'
, NULL
, 'PJ'
, NULL
, 'WIP'
, NULL
, 'INV'
, NULL
, 'BTC'
, NULL
, NVL(EI.BILL_JOB_BILLING_TITLE
, JOB.NAME))
, EI.EXPENDITURE_TYPE
, ET.EXPENDITURE_CATEGORY
, EI.SYSTEM_LINKAGE_FUNCTION
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, EI.EXPENDITURE_ITEM_DATE
, EI.QUANTITY
, PA_UTILS4.GET_UNIT_OF_MEASURE_M(EI.UNIT_OF_MEASURE
, EI.EXPENDITURE_TYPE)
, EI.BILL_RATE
, EI.BILL_AMOUNT
, EI.RAW_COST
, EI.BURDEN_COST
, NVL(EI.ADJUSTED_REVENUE
, EI.RAW_REVENUE)
, EI.ACCRUED_REVENUE
, EI.COST_DISTRIBUTED_FLAG
, EI.REVENUE_DISTRIBUTED_FLAG
, EI.BILLABLE_FLAG
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(EI.ORGANIZATION_ID)
, CDL.SYSTEM_REFERENCE2
, CDL.SYSTEM_REFERENCE3
, ASG1.PRIMARY_FLAG
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_EXCHANGE_RATE
, EI.INVPROC_CURRENCY_CODE
, EI.BILL_TRANS_CURRENCY_CODE
, EI.BILL_TRANS_BILL_AMOUNT
, EI.DOCUMENT_HEADER_ID
, EI.DOCUMENT_DISTRIBUTION_ID
, EI.DOCUMENT_PAYMENT_ID
, EI.DOCUMENT_LINE_NUMBER
, EI.DOCUMENT_TYPE
, EI.DOCUMENT_DISTRIBUTION_TYPE
, P.ORG_ID
, EI.EVENT_NUM
FROM PA_PROJECTS P
, PA_TASKS T
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
, PA_COST_DIST_LINES_ALL_BAS CDL
, PA_EXPENDITURE_TYPES ET
, PER_ALL_ASSIGNMENTS_F ASG1
, PER_ALL_PEOPLE_F PER
, PER_JOBS JOB
, PO_VENDORS VEND
WHERE T.TASK_ID = EI.TASK_ID
AND P.PROJECT_ID = T.PROJECT_ID
AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND E.INCURRED_BY_PERSON_ID = PER.PERSON_ID (+)
AND EI.EXPENDITURE_ITEM_DATE BETWEEN NVL(PER.EFFECTIVE_START_DATE
, EI.EXPENDITURE_ITEM_DATE-1)
AND NVL(PER.EFFECTIVE_END_DATE
, EI.EXPENDITURE_ITEM_DATE+1)
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID (+)
AND CDL.LINE_NUM (+) = 1
AND EI.VENDOR_ID = VEND.VENDOR_ID (+)
AND PER.PERSON_ID = ASG1.PERSON_ID (+)
AND EI.EXPENDITURE_ITEM_DATE BETWEEN NVL(ASG1.EFFECTIVE_START_DATE
, EI.EXPENDITURE_ITEM_DATE-1)
AND NVL(ASG1.EFFECTIVE_END_DATE
, EI.EXPENDITURE_ITEM_DATE+1)
AND ASG1.JOB_ID = JOB.JOB_ID (+)
AND ASG1.PRIMARY_FLAG (+) ='Y'
AND (ASG1.ASSIGNMENT_TYPE IN (DECODE(NVL(PER.CURRENT_NPW_FLAG
, 'N')
, 'N'
, 'E'
, 'C')) OR ASG1.ASSIGNMENT_TYPE IS NULL)

Columns