VIEW: APPS.IGW_APPLICANT_DEPT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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