FND Design Data [Home] [Help]

View: IGWBV_GRANT_PROPOSAL_APPROVAL

Product: IGW - Grants Proposal
Description:
Implementation/DBA Data: ViewAPPS.IGWBV_GRANT_PROPOSAL_APPROVAL
View Text

SELECT PR.PROPOSAL_NUMBER
, PAR.RUN_NUMBER
, PAR.RUN_ID
, PR.PROPOSAL_ID
, PAR.STATUS_CODE
, PAR.STATUS_DATE
FROM IGW_PROP_APPROVAL_RUNS PAR
, IGW_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = PAR.PROPOSAL_ID WITH READ ONLY

Columns

Name
PROPOSAL_NUMBER
RUN_NUMBER
APPROVAL_RUN_ID
PROPOSAL_ID
STATUS_CODE
STATUS_DATE