[Home] [Help]
View: IGWBV_GRANT_PRPSL_BDGT_PERSON
View Text
SELECT PR.PROPOSAL_NUMBER
, BUD_PERS.VERSION_ID
, '_LA:BUD_PERS.APPOINTMENT_TYPE_CODE:IGW_LOOKUPS_V:IGW_APPOINTMENT_TYPE:MEANING'
, BUD_PERS.EFFECTIVE_DATE
, BUD_PERS.CALCULATION_BASE
, PR.PROPOSAL_ID
, BUD_PERS.PERSON_ID
, BUD_PERS.LAST_UPDATE_DATE
, BUD_PERS.LAST_UPDATED_BY
, BUD_PERS.CREATION_DATE
, BUD_PERS.CREATED_BY
FROM IGW_BUDGET_PERSONS BUD_PERS
, IGW_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = BUD_PERS.PROPOSAL_ID WITH READ ONLY
Columns
Name |
PROPOSAL_NUMBER |
BUDGET_VERSION_ID |
"_LA:APPOINTMENT_TYPE" |
EFFECTIVE_DATE |
CALCULATION_BASE |
PROPOSAL_ID |
PERSON_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |