DBA Data[Home] [Help]

VIEW: APPS.IGW_PROP_PERSON_BIOSKETCH_V

Source

View Text - Preformatted

SELECT pppb.rowid row_id, pppb.proposal_id, pppb.person_biosketch_id, pppb.show_flag, pppb.line_sequence prop_line_sequence, pppb.last_update_date, pppb.last_updated_by, pppb.creation_date, pppb.created_by, pppb.last_update_login, ppb.person_id, ppb.biosketch_type, ppb.line_sequence person_line_sequence, ppb.line_description, ppb.enable_flag from igw_prop_person_biosketch pppb, igw_person_biosketch ppb where pppb.person_biosketch_id = ppb.person_biosketch_id
View Text - HTML Formatted

SELECT PPPB.ROWID ROW_ID
, PPPB.PROPOSAL_ID
, PPPB.PERSON_BIOSKETCH_ID
, PPPB.SHOW_FLAG
, PPPB.LINE_SEQUENCE PROP_LINE_SEQUENCE
, PPPB.LAST_UPDATE_DATE
, PPPB.LAST_UPDATED_BY
, PPPB.CREATION_DATE
, PPPB.CREATED_BY
, PPPB.LAST_UPDATE_LOGIN
, PPB.PERSON_ID
, PPB.BIOSKETCH_TYPE
, PPB.LINE_SEQUENCE PERSON_LINE_SEQUENCE
, PPB.LINE_DESCRIPTION
, PPB.ENABLE_FLAG
FROM IGW_PROP_PERSON_BIOSKETCH PPPB
, IGW_PERSON_BIOSKETCH PPB
WHERE PPPB.PERSON_BIOSKETCH_ID = PPB.PERSON_BIOSKETCH_ID