[Home] [Help]
View: IGW_PRPO_ORG_TYPES_V
Product: | IGW - Grants Proposal |
Description: | View displays the type of organization |
Implementation/DBA Data: |
APPS.IGW_PRPO_ORG_TYPES_V
|
View Text
SELECT PROP.PROPOSAL_ID
, ORGTYP.ORGANIZATION_ID
, LKUP.LOOKUP_CODE
, LKUP.MEANING
FROM IGW_ORG_TYPES ORGTYP
, IGW_LOOKUPS_V LKUP
, IGW_PROPOSALS PROP
WHERE LKUP.LOOKUP_TYPE = 'IGW_ORGANIZATION_TYPES'
AND LKUP.LOOKUP_CODE = ORGTYP.ORGANIZATION_TYPE_CODE
AND PROP.SUBMITTING_ORGANIZATION_ID = ORGTYP.ORGANIZATION_ID
Columns
Name |
PROPOSAL_ID |
ORGANIZATION_ID |
ORG_TYPE_CODE |
ORG_TYPE |