View: AS_FUND_CONTACTS_V

Product:	AS - Sales Foundation
Description:	View to show fund contact details.
Implementation/DBA Data:	APPS.AS_FUND_CONTACTS_V

View Text

SELECT FB.FUND_ID
, FB.STRATEGY STRATEGY
, FTL.NAME FUND_NAME
, FB.TARGET_CAP TARGET_CAP
, FB.MANAGEMENT_ASSETS MANAGEMENT_ASSETS
, FB.ISSUE_GROUP_ID ISSUE_GROUP_ID
, FB.ISSUE_ID FUND_ISSUE_ID
, HZ.PARTY_ID CONTACT_PARTY_ID
, HZ.PARTY_NAME CONTACT_PARTY_NAME
, HZ.PARTY_TYPE CONTACT_PARTY_TYPE
, FCNT.CONTACT_ROLE_CODE CONTACT_ROLE_CODE
, FCNT.CREATED_BY CREATED_BY
, FCNT.CREATION_DATE CREATION_DATE
, FCNT.LAST_UPDATED_BY LAST_UPDATED_BY
, FCNT.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AS_FUNDS_B FB
, AS_FUNDS_TL FTL
, AS_FUND_CONTACTS FCNT
, HZ_PARTIES HZ
WHERE HZ.PARTY_ID = FCNT.PARTY_ID
AND FB.FUND_ID = FTL.FUND_ID
AND FTL.LANGUAGE = USERENV('LANG')
AND FB.FUND_ID = FCNT.FUND_ID

Columns