VIEW: APPS.AS_FUND_ISSUES_V

Source

View Text - Preformatted

SELECT FB.FUND_ID , FB.STRATEGY , FTL.NAME FUND_NAME , FB.TARGET_CAP , FB.MANAGEMENT_ASSETS , IGB.ISSUE_GROUP_ID , IGTL.NAME ISSUE_GROUP_NAME , IGB.ISSUE_GROUP_TYPE_CODE , ISB.ISSUE_ID , IGMAP.LAST_INTEREST_DATE , IGMAP.TARGET_PRICE , IGMAP.BUY_SELL_INDICATOR , IGMAP.HOLDING , IGMAP.CURRENCY_CODE , IGMAP.NET_CHANGE , ISB.ISSUE_TYPE , ISTL.NAME ISSUE_NAME , ISB.SECTOR , ISB.PARTY_ID ISSUER_PARTY_ID , IGMAP.CREATED_BY , IGMAP.CREATION_DATE , IGMAP.LAST_UPDATED_BY , IGMAP.LAST_UPDATE_DATE FROM AS_FUNDS_B FB, AS_FUNDS_TL FTL, AS_ISSUE_GROUPS_B IGB, AS_ISSUE_GROUPS_TL IGTL, AS_GROUP_ISSUE_MAP IGMAP, AS_ISSUES_B ISB , AS_ISSUES_TL ISTL WHERE FB.FUND_ID = FTL.FUND_ID AND FTL.LANGUAGE = userenv('LANG') AND FB.ISSUE_GROUP_ID = IGB.ISSUE_GROUP_ID AND IGB.ISSUE_GROUP_ID = IGTL.ISSUE_GROUP_ID AND IGTL.LANGUAGE = userenv('LANG') AND IGB.ISSUE_GROUP_ID = IGMAP.ISSUE_GROUP_ID AND ISB.ISSUE_ID = ISTL.ISSUE_ID AND ISTL.LANGUAGE = userenv('LANG') AND ISB.ISSUE_ID = IGMAP.ISSUE_ID

View Text - HTML Formatted

SELECT FB.FUND_ID
, FB.STRATEGY
, FTL.NAME FUND_NAME
, FB.TARGET_CAP
, FB.MANAGEMENT_ASSETS
, IGB.ISSUE_GROUP_ID
, IGTL.NAME ISSUE_GROUP_NAME
, IGB.ISSUE_GROUP_TYPE_CODE
, ISB.ISSUE_ID
, IGMAP.LAST_INTEREST_DATE
, IGMAP.TARGET_PRICE
, IGMAP.BUY_SELL_INDICATOR
, IGMAP.HOLDING
, IGMAP.CURRENCY_CODE
, IGMAP.NET_CHANGE
, ISB.ISSUE_TYPE
, ISTL.NAME ISSUE_NAME
, ISB.SECTOR
, ISB.PARTY_ID ISSUER_PARTY_ID
, IGMAP.CREATED_BY
, IGMAP.CREATION_DATE
, IGMAP.LAST_UPDATED_BY
, IGMAP.LAST_UPDATE_DATE
FROM AS_FUNDS_B FB
, AS_FUNDS_TL FTL
, AS_ISSUE_GROUPS_B IGB
, AS_ISSUE_GROUPS_TL IGTL
, AS_GROUP_ISSUE_MAP IGMAP
, AS_ISSUES_B ISB
, AS_ISSUES_TL ISTL
WHERE FB.FUND_ID = FTL.FUND_ID
AND FTL.LANGUAGE = USERENV('LANG')
AND FB.ISSUE_GROUP_ID = IGB.ISSUE_GROUP_ID
AND IGB.ISSUE_GROUP_ID = IGTL.ISSUE_GROUP_ID
AND IGTL.LANGUAGE = USERENV('LANG')
AND IGB.ISSUE_GROUP_ID = IGMAP.ISSUE_GROUP_ID
AND ISB.ISSUE_ID = ISTL.ISSUE_ID
AND ISTL.LANGUAGE = USERENV('LANG')
AND ISB.ISSUE_ID = IGMAP.ISSUE_ID