VIEW: APPS.AS_FUND_CONTACTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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