SELECT P.PROPOSAL_ID , P.LEAD_ORGANIZATION_ID , O.NAME , OD.NIH_SUBDIVISION_CODE , L.MEANING MAJOR_SUBDIVISION FROM IGW_PROPOSALS_ALL P , HR_ALL_ORGANIZATION_UNITS O , IGW_ORG_DETAILS OD , FND_LOOKUPS L WHERE O.ORGANIZATION_ID = P.LEAD_ORGANIZATION_ID AND OD.ORGANIZATION_ID = P.LEAD_ORGANIZATION_ID AND L.LOOKUP_TYPE(+) = 'IGW_NIH_MAJOR_SUBDIVISION' AND L.LOOKUP_CODE(+) = OD.NIH_SUBDIVISION_CODE