[Home] [Help]
View: IGW_ORGANIZATION_TYPES_V
Product: | IGW - Grants Proposal |
Description: | View displays details of applicant organization |
Implementation/DBA Data: |
APPS.IGW_ORGANIZATION_TYPES_V
|
View Text
SELECT P.PROPOSAL_ID
, P.PROPOSAL_NUMBER
, P.SUBMITTING_ORGANIZATION_ID
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, 'B9')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, '21')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, '22'
, '23')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, 'A2')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, '27')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, '2R')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, '2F')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, 'C6')
, IGW_REPORT_PROCESSING.GET_ORG_TYPE(P.SUBMITTING_ORGANIZATION_ID
, 'A8')
FROM IGW_PROPOSALS_ALL P
Columns
Name |
PROPOSAL_ID |
PROPOSAL_NUMBER |
ORGANIZATION_ID |
GENERAL |
SMALL_BUSINESS |
MINORITY_BUSINESS |
WOMEN_BUSINESS |
DISADVANTAGED |
FEDERAL |
STATE |
LOCAL |
NON_PROFIT |