View: PAFV_EXPENDITURES

Product:	PA - Projects
Description:	Business view to show information about the expenditures entered. Business view to show information about the expenditures entered.
Implementation/DBA Data:	APPS.PAFV_EXPENDITURES

View Text

SELECT PEA.EXPENDITURE_ID
, PEA.DESCRIPTION
, PEA.CONTROL_TOTAL_AMOUNT
, PEA.EXPENDITURE_ENDING_DATE
, PEA.EXPENDITURE_GROUP
, PEGA.DESCRIPTION
, PEA.INCURRED_BY_PERSON_ID
, PAPF.FULL_NAME
, PEA.INCURRED_BY_ORGANIZATION_ID
, TL1.NAME
, PEA.ORG_ID
, TL2.NAME
, PEA.ORIG_EXP_TXN_REFERENCE1
, PEA.ORIG_USER_EXP_TXN_REFERENCE
, PEA.VENDOR_ID
, PEA.ORIG_EXP_TXN_REFERENCE2
, PEA.ORIG_EXP_TXN_REFERENCE3
, PEA.OVERRIDING_APPROVER_PERSON_ID
, PEA.WF_STATUS_CODE
, PEA.USER_BATCH_NAME
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATION_DATE
, PEA.CREATED_BY
, PEA.TRANSFER_STATUS_CODE
, '_LA:EXPENDITURE_STATUS_CODE:PA_LOOKUPS:EXPENDITURE STATUS:MEANING'
, '_LA:EXPENDITURE_CLASS_CODE:PA_LOOKUPS:EXPENDITURE CLASS CODE:MEANING'
, '_DF:PA:PA_EXPENDITURES_DESC_FLEX:PEA'
FROM PA_EXPENDITURES_ALL PEA
, HR_ALL_ORGANIZATION_UNITS_TL TL1
, HR_ALL_ORGANIZATION_UNITS_TL TL2
, PER_ALL_PEOPLE_F PAPF
, PA_EXPENDITURE_GROUPS_ALL PEGA
, PER_ALL_ASSIGNMENTS_F ASGN
WHERE PEA.EXPENDITURE_GROUP = PEGA.EXPENDITURE_GROUP(+)
AND ( NVL(PEA.ORG_ID
, -99) = NVL(PEGA.ORG_ID
, -99) OR PEGA.EXPENDITURE_GROUP IS NULL)
AND PEA.INCURRED_BY_ORGANIZATION_ID = TL1.ORGANIZATION_ID(+)
AND PEA.ORG_ID=TL2.ORGANIZATION_ID(+)
AND TL1.LANGUAGE (+) = USERENV('LANG')
AND TL2.LANGUAGE (+) = USERENV('LANG')
AND PEA.INCURRED_BY_PERSON_ID = PAPF.PERSON_ID(+)
AND PEA.INCURRED_BY_ORGANIZATION_ID = ASGN.ORGANIZATION_ID
AND PAPF.PERSON_ID = ASGN.PERSON_ID
AND PEA.EXPENDITURE_ENDING_DATE BETWEEN ASGN.EFFECTIVE_START_DATE
AND ASGN.EFFECTIVE_END_DATE
AND (PAPF.CURRENT_EMPLOYEE_FLAG = 'Y' OR PAPF.CURRENT_NPW_FLAG = 'Y')
AND ASGN.PRIMARY_FLAG = 'Y'
AND (PAPF.EMPLOYEE_NUMBER IS NOT NULL OR PAPF.NPW_NUMBER IS NOT NULL)
AND ASGN.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND ASGN.JOB_ID IS NOT NULL
AND '_SEC:PEA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns