Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AS_FUND_DETAILS_V |
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')