View: PA_EXPENDITURE_GROUPS_V

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

View Text

SELECT E.ROWID ROW_ID
, E.EXPENDITURE_GROUP
, E.EXPENDITURE_ENDING_DATE
, E.EXPENDITURE_GROUP_STATUS_CODE
, L1.MEANING EXPENDITURE_GROUP_STATUS_M
, E.SYSTEM_LINKAGE_FUNCTION
, SL.MEANING SYSTEM_LINKAGE
, E.DESCRIPTION
, E.CONTROL_COUNT
, E.CONTROL_TOTAL_AMOUNT
, E.TRANSACTION_SOURCE
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, P.FULL_NAME CREATED_BY_EMPLOYEE_NAME
, NVL(P.EMPLOYEE_NUMBER
, P.NPW_NUMBER) CREATED_BY_EMPLOYEE_NUMBER
, TR.USER_TRANSACTION_SOURCE
, TR.ALLOW_ADJUSTMENTS_FLAG
, TR.ALLOW_REVERSAL_FLAG
, E.PERIOD_ACCRUAL_FLAG
, E.ORG_ID
FROM PER_PEOPLE_F P
, FND_USER F
, PA_TRANSACTION_SOURCES TR
, PA_SYSTEM_LINKAGES SL
, PA_LOOKUPS L1
, PA_EXPENDITURE_GROUPS E
WHERE E.CREATED_BY = F.USER_ID (+)
AND F.EMPLOYEE_ID = P.PERSON_ID (+)
AND E.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE (+)
AND P.EFFECTIVE_END_DATE (+)
AND SL.FUNCTION = E.SYSTEM_LINKAGE_FUNCTION
AND L1.LOOKUP_TYPE = 'EXPENDITURE GROUP STATUS'
AND L1.LOOKUP_CODE = E.EXPENDITURE_GROUP_STATUS_CODE

Columns