View: PA_EXPENDITURES_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_EXPENDITURES_V

View Text

SELECT E.ROWID ROW_ID
, E.EXPENDITURE_ID
, E.EXPENDITURE_STATUS_CODE
, E.EXPENDITURE_ENDING_DATE
, E.EXPENDITURE_CLASS_CODE
, E.INCURRED_BY_PERSON_ID
, P.FULL_NAME INCURRED_BY_EMPLOYEE_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, EMPLOYEE_NUMBER
, DECODE(CURRENT_NPW_FLAG
, 'Y'
, NPW_NUMBER
, NULL)) INCURRED_BY_EMPLOYEE_NUMBER
, E.INCURRED_BY_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(E.INCURRED_BY_ORGANIZATION_ID )
, E.EXPENDITURE_GROUP
, E.CONTROL_TOTAL_AMOUNT
, E.ENTERED_BY_PERSON_ID
, E.DESCRIPTION
, E.INITIAL_SUBMISSION_DATE
, E.DENOM_CURRENCY_CODE
, E.ACCT_CURRENCY_CODE
, E.ACCT_RATE_DATE
, E.ACCT_RATE_TYPE
, E.ACCT_EXCHANGE_RATE
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.ORIG_EXP_TXN_REFERENCE1
, E.ORIG_USER_EXP_TXN_REFERENCE
, E.VENDOR_ID
, E.ORIG_EXP_TXN_REFERENCE2
, E.ORIG_EXP_TXN_REFERENCE3
, E.OVERRIDING_APPROVER_PERSON_ID
, E.WF_STATUS_CODE
, E.TRANSFER_STATUS_CODE
, E.USER_BATCH_NAME
, E.PERSON_TYPE
, E.ORG_ID
FROM PA_EXPENDITURES E
, PER_ALL_PEOPLE_F P
WHERE E.INCURRED_BY_PERSON_ID = P.PERSON_ID(+)
AND ( P.ROWID IS NULL OR P.ROWID IN ( SELECT MAX(P1.ROWID)
FROM PER_ALL_PEOPLE_F P1
WHERE P.PERSON_ID = P1.PERSON_ID
AND DECODE (E.PERSON_TYPE
, 'CWK'
, P1.CURRENT_NPW_FLAG
, P1.CURRENT_EMPLOYEE_FLAG) = 'Y'
AND P1.EFFECTIVE_START_DATE <= E.EXPENDITURE_ENDING_DATE
AND P1.EFFECTIVE_END_DATE >= E.EXPENDITURE_ENDING_DATE - 6))

Columns