VIEW: APPS.IGW_PROP_V

Source

View Text - Preformatted

SELECT ipa.proposal_id, ipa.proposal_number, ipa.proposal_type_code, ipp.person_id pi_id, ppx.full_name pi_name, ipa.sponsor_id, substrb(p.party_name,1,50) sponsor_name, igw_view_parameters.get_project_location_id (ipa.proposal_id) project_location_id, igw_view_parameters.get_project_location_name(igw_view_parameters.get_project_location_id (ipa.proposal_id) ) project_location_name, igw_view_parameters.get_major_goals(ipa.proposal_id) major_goals, ipa.proposal_start_date, ipa.proposal_end_date, igw_prop_costs.get_annual_direct_costs ( ipa.proposal_id) annual_direct_cost, igw_prop_costs.get_total_costs (ipa.proposal_id) total_cost, ipa.proposal_title, ipa.sponsor_action_code, ipa.last_update_date, ipa.last_updated_by, ipa.creation_date, ipa.created_by, ipa.last_update_login from igw_proposals ipa, igw_prop_persons ipp, per_people_x ppx, hz_parties p, hz_cust_accounts c WHERE ipp.proposal_id = ipa.proposal_id AND ipp.pi_flag = 'Y' AND ppx.person_id = ipp.person_id AND c.party_id = p.party_id and c.cust_account_id = ipa.sponsor_id

View Text - HTML Formatted

SELECT IPA.PROPOSAL_ID
, IPA.PROPOSAL_NUMBER
, IPA.PROPOSAL_TYPE_CODE
, IPP.PERSON_ID PI_ID
, PPX.FULL_NAME PI_NAME
, IPA.SPONSOR_ID
, SUBSTRB(P.PARTY_NAME
, 1
, 50) SPONSOR_NAME
, IGW_VIEW_PARAMETERS.GET_PROJECT_LOCATION_ID (IPA.PROPOSAL_ID) PROJECT_LOCATION_ID
, IGW_VIEW_PARAMETERS.GET_PROJECT_LOCATION_NAME(IGW_VIEW_PARAMETERS.GET_PROJECT_LOCATION_ID (IPA.PROPOSAL_ID) ) PROJECT_LOCATION_NAME
, IGW_VIEW_PARAMETERS.GET_MAJOR_GOALS(IPA.PROPOSAL_ID) MAJOR_GOALS
, IPA.PROPOSAL_START_DATE
, IPA.PROPOSAL_END_DATE
, IGW_PROP_COSTS.GET_ANNUAL_DIRECT_COSTS ( IPA.PROPOSAL_ID) ANNUAL_DIRECT_COST
, IGW_PROP_COSTS.GET_TOTAL_COSTS (IPA.PROPOSAL_ID) TOTAL_COST
, IPA.PROPOSAL_TITLE
, IPA.SPONSOR_ACTION_CODE
, IPA.LAST_UPDATE_DATE
, IPA.LAST_UPDATED_BY
, IPA.CREATION_DATE
, IPA.CREATED_BY
, IPA.LAST_UPDATE_LOGIN
FROM IGW_PROPOSALS IPA
, IGW_PROP_PERSONS IPP
, PER_PEOPLE_X PPX
, HZ_PARTIES P
, HZ_CUST_ACCOUNTS C
WHERE IPP.PROPOSAL_ID = IPA.PROPOSAL_ID
AND IPP.PI_FLAG = 'Y'
AND PPX.PERSON_ID = IPP.PERSON_ID
AND C.PARTY_ID = P.PARTY_ID
AND C.CUST_ACCOUNT_ID = IPA.SPONSOR_ID