VIEW: APPS.IGW_PROP_PERSONS_V

Source

View Text - Preformatted

SELECT rowidtochar(pp.rowid) row_id, pp.record_version_number, pp.proposal_id, pp.person_id, p.full_name, pp.person_sequence, pp.proposal_role_code, l.meaning proposal_role_desc, pp.pi_flag, pp.key_person_flag, pp.percent_effort, pp.person_organization_id, org.name person_unit_name, pp.last_update_date, pp.last_updated_by, pp.creation_date, pp.created_by, pp.last_update_login from igw_prop_persons pp, per_people_x p, fnd_lookups l, hr_organization_units org WHERE p.person_id = pp.person_id and l.lookup_code = pp.proposal_role_code and l.lookup_type = 'IGW_PROPOSAL_ROLE_TYPES' and org.organization_id(+) = pp.person_organization_id

View Text - HTML Formatted

SELECT ROWIDTOCHAR(PP.ROWID) ROW_ID
, PP.RECORD_VERSION_NUMBER
, PP.PROPOSAL_ID
, PP.PERSON_ID
, P.FULL_NAME
, PP.PERSON_SEQUENCE
, PP.PROPOSAL_ROLE_CODE
, L.MEANING PROPOSAL_ROLE_DESC
, PP.PI_FLAG
, PP.KEY_PERSON_FLAG
, PP.PERCENT_EFFORT
, PP.PERSON_ORGANIZATION_ID
, ORG.NAME PERSON_UNIT_NAME
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.CREATION_DATE
, PP.CREATED_BY
, PP.LAST_UPDATE_LOGIN
FROM IGW_PROP_PERSONS PP
, PER_PEOPLE_X P
, FND_LOOKUPS L
, HR_ORGANIZATION_UNITS ORG
WHERE P.PERSON_ID = PP.PERSON_ID
AND L.LOOKUP_CODE = PP.PROPOSAL_ROLE_CODE
AND L.LOOKUP_TYPE = 'IGW_PROPOSAL_ROLE_TYPES'
AND ORG.ORGANIZATION_ID(+) = PP.PERSON_ORGANIZATION_ID