VIEW: APPS.AS_ISSUE_GROUP_PARTIES_V

Source

View Text - Preformatted

SELECT IGB.ISSUE_GROUP_ID ISSUE_GROUP_ID , IGTL.NAME ISSUE_GROUP_NAME , IGB.ISSUE_GROUP_TYPE_CODE ISSUE_GROUP_TYPE_CODE , HZ.PARTY_ID PARTY_ID , HZ.PARTY_NAME PARTY_NAME , HZ.PARTY_TYPE PARTY_TYPE , IGMAP.LAST_INTEREST_DATE LAST_INTEREST_DATE , IGMAP.NET_CHANGE NET_CHANGE , 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_PARTY_MAP IGMAP, HZ_PARTIES HZ WHERE IGB.ISSUE_GROUP_ID = IGTL.ISSUE_GROUP_ID AND IGTL.LANGUAGE = userenv('LANG') AND IGB.ISSUE_GROUP_ID = IGMAP.ISSUE_GROUP_ID AND HZ.PARTY_ID = IGMAP.PARTY_ID

View Text - HTML Formatted

SELECT IGB.ISSUE_GROUP_ID ISSUE_GROUP_ID
, IGTL.NAME ISSUE_GROUP_NAME
, IGB.ISSUE_GROUP_TYPE_CODE ISSUE_GROUP_TYPE_CODE
, HZ.PARTY_ID PARTY_ID
, HZ.PARTY_NAME PARTY_NAME
, HZ.PARTY_TYPE PARTY_TYPE
, IGMAP.LAST_INTEREST_DATE LAST_INTEREST_DATE
, IGMAP.NET_CHANGE NET_CHANGE
, 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_PARTY_MAP IGMAP
, HZ_PARTIES HZ
WHERE IGB.ISSUE_GROUP_ID = IGTL.ISSUE_GROUP_ID
AND IGTL.LANGUAGE = USERENV('LANG')
AND IGB.ISSUE_GROUP_ID = IGMAP.ISSUE_GROUP_ID
AND HZ.PARTY_ID = IGMAP.PARTY_ID