VIEW: APPS.AS_FUND_DETAILS_V

Source

View Text - Preformatted

SELECT FB.FUND_ID , FB.STRATEGY , FTL.NAME FUND_NAME , FB.TARGET_CAP , FB.MANAGEMENT_ASSETS , IGTL.ISSUE_GROUP_ID , IGTL.NAME ISSUE_GROUP_NAME , HZ.PARTY_ID MANAGING_ORG_PARTY_ID , HZ.PARTY_NAME MANAGING_ORG_PARTY_NAME , HZ.PARTY_TYPE MANAGING_ORG_PARTY_TYPE , IB.ISSUE_ID FUND_ISSUE_ID , ITL.NAME FUND_ISSUE_NAME , IB.SECTOR FUND_ISSUE_SECTOR , IB.PARTY_ID FUND_ISSUER_PARTY_ID , IB.ISSUE_TYPE FUND_ISSUE_TYPE , FB.CREATED_BY , FB.CREATION_DATE , FB.LAST_UPDATED_BY , FB.LAST_UPDATE_DATE FROM AS_ISSUE_GROUPS_TL IGTL, AS_FUNDS_B FB, AS_FUNDS_TL FTL, AS_ISSUES_B IB, AS_ISSUES_TL ITL, HZ_PARTIES HZ WHERE IGTL.ISSUE_GROUP_ID = FB.ISSUE_GROUP_ID AND IGTL.LANGUAGE = userenv('LANG') AND HZ.PARTY_ID = FB.PARTY_ID AND FB.ISSUE_ID = IB.ISSUE_ID(+) AND FB.FUND_ID = FTL.FUND_ID AND FTL.LANGUAGE = userenv('LANG') AND IB.ISSUE_ID = ITL.ISSUE_ID AND ITL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT FB.FUND_ID
, FB.STRATEGY
, FTL.NAME FUND_NAME
, FB.TARGET_CAP
, FB.MANAGEMENT_ASSETS
, IGTL.ISSUE_GROUP_ID
, IGTL.NAME ISSUE_GROUP_NAME
, HZ.PARTY_ID MANAGING_ORG_PARTY_ID
, HZ.PARTY_NAME MANAGING_ORG_PARTY_NAME
, HZ.PARTY_TYPE MANAGING_ORG_PARTY_TYPE
, IB.ISSUE_ID FUND_ISSUE_ID
, ITL.NAME FUND_ISSUE_NAME
, IB.SECTOR FUND_ISSUE_SECTOR
, IB.PARTY_ID FUND_ISSUER_PARTY_ID
, IB.ISSUE_TYPE FUND_ISSUE_TYPE
, FB.CREATED_BY
, FB.CREATION_DATE
, FB.LAST_UPDATED_BY
, FB.LAST_UPDATE_DATE
FROM AS_ISSUE_GROUPS_TL IGTL
, AS_FUNDS_B FB
, AS_FUNDS_TL FTL
, AS_ISSUES_B IB
, AS_ISSUES_TL ITL
, HZ_PARTIES HZ
WHERE IGTL.ISSUE_GROUP_ID = FB.ISSUE_GROUP_ID
AND IGTL.LANGUAGE = USERENV('LANG')
AND HZ.PARTY_ID = FB.PARTY_ID
AND FB.ISSUE_ID = IB.ISSUE_ID(+)
AND FB.FUND_ID = FTL.FUND_ID
AND FTL.LANGUAGE = USERENV('LANG')
AND IB.ISSUE_ID = ITL.ISSUE_ID
AND ITL.LANGUAGE = USERENV('LANG')