Product: | AS - Sales Foundation |
---|---|
Description: | THIS VIEW DISPLAYS ALL THE ISSUES FOR THE ISSUE GROUPS |
Implementation/DBA Data: | APPS.AS_ISSUE_GROUP_ISSUES_V |
SELECT IGB.ISSUE_GROUP_ID ISSUE_GROUP_ID
, IGTL.NAME ISSUE_GROUP_NAME
, IGB.ISSUE_GROUP_TYPE_CODE ISSUE_GROUP_TYPE_CODE
, ISB.ISSUE_ID ISSUE_ID
, IGMAP.LAST_INTEREST_DATE LAST_INTEREST_DATE
, IGMAP.TARGET_PRICE TARGET_PRICE
, IGMAP.BUY_SELL_INDICATOR BUY_SEL_INDICATOR
, IGMAP.HOLDING HOLDING
, IGMAP.CURRENCY_CODE CURRENCY_CODE
, IGMAP.NET_CHANGE NET_CHANGE
, ISB.ISSUE_TYPE ISSUE_TYPE
, ISTL.NAME ISSUE_NAME
, ISB.SECTOR SECTOR
, ISB.PARTY_ID ISSUER_PARTY_ID
, IGMAP.CREATED_BY CREATED_BY
, IGMAP.CREATION_DATE CREATION_DATE
, IGMAP.LAST_UPDATED_BY LAST_UPDATED_BY
, IGMAP.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AS_ISSUE_GROUPS_B IGB
, AS_ISSUE_GROUPS_TL IGTL
, AS_GROUP_ISSUE_MAP IGMAP
, AS_ISSUES_B ISB
, AS_ISSUES_TL ISTL
WHERE 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