View: AS_FUND_ISSUES_V

Product:	AS - Sales Foundation
Description:	This group displays Issues of a Fund.
Implementation/DBA Data:	APPS.AS_FUND_ISSUES_V

View Text

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

Columns