VIEW: APPS.AS_ISSUE_GROUP_DETAILS_V

Source

View Text - Preformatted

SELECT IGB.ISSUE_GROUP_ID ISSUE_GROUP_ID , IGTL.NAME ISSUE_GROUP_NAME , IGB.START_DATE_ACTIVE START_DATE_ACTIVE , IGB.END_DATE_ACTIVE END_DATE_ACTIVE , IGB.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERNCE , IGB.ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID , IGTYPE.ISSUE_GROUP_TYPE_CODE ISSUE_GROUP_TYPE_CODE , IGTYPE.MEANING ISSUE_GROUP_TYPE_MEANING , IGTYPE.DESCRIPTION ISSUE_GROUP_TYPE_DESCRIPTION , IGTYPE.CLIENT_CONTACT_ENABLED_FLAG CLIENT_CONTACT_ENABLED_FLAG , IGTYPE.CLIENT_ORG_ENABLED_FLAG CLIENT_ORG_ENABLED_FLAG , IGID.ISSUE_GROUP_IDFR_ID ISSUE_GROUP_IDFR_ID , IGID.SCHEME SCHEME , IGID.VALUE VALUE , IGID.SEARCH_CODE SEARCH_CODE , IGB.CREATED_BY CREATED_BY , IGB.CREATION_DATE CREATION_DATE , IGB.LAST_UPDATED_BY LAST_UPDATED_BY , IGB.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM AS_ISSUE_GROUPS_B IGB, AS_ISSUE_GROUPS_TL IGTL, AS_ISSUE_GROUP_TYPES IGTYPE, AS_ISSUE_GROUP_IDFR IGID WHERE IGB.ISSUE_GROUP_ID = IGTL.ISSUE_GROUP_ID AND IGTL.LANGUAGE = userenv('LANG') AND IGB.ISSUE_GROUP_ID = IGID.ISSUE_GROUP_ID(+) AND IGB.ISSUE_GROUP_TYPE_CODE = IGTYPE.ISSUE_GROUP_TYPE_CODE AND IGTYPE.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT IGB.ISSUE_GROUP_ID ISSUE_GROUP_ID
, IGTL.NAME ISSUE_GROUP_NAME
, IGB.START_DATE_ACTIVE START_DATE_ACTIVE
, IGB.END_DATE_ACTIVE END_DATE_ACTIVE
, IGB.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERNCE
, IGB.ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID
, IGTYPE.ISSUE_GROUP_TYPE_CODE ISSUE_GROUP_TYPE_CODE
, IGTYPE.MEANING ISSUE_GROUP_TYPE_MEANING
, IGTYPE.DESCRIPTION ISSUE_GROUP_TYPE_DESCRIPTION
, IGTYPE.CLIENT_CONTACT_ENABLED_FLAG CLIENT_CONTACT_ENABLED_FLAG
, IGTYPE.CLIENT_ORG_ENABLED_FLAG CLIENT_ORG_ENABLED_FLAG
, IGID.ISSUE_GROUP_IDFR_ID ISSUE_GROUP_IDFR_ID
, IGID.SCHEME SCHEME
, IGID.VALUE VALUE
, IGID.SEARCH_CODE SEARCH_CODE
, IGB.CREATED_BY CREATED_BY
, IGB.CREATION_DATE CREATION_DATE
, IGB.LAST_UPDATED_BY LAST_UPDATED_BY
, IGB.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AS_ISSUE_GROUPS_B IGB
, AS_ISSUE_GROUPS_TL IGTL
, AS_ISSUE_GROUP_TYPES IGTYPE
, AS_ISSUE_GROUP_IDFR IGID
WHERE IGB.ISSUE_GROUP_ID = IGTL.ISSUE_GROUP_ID
AND IGTL.LANGUAGE = USERENV('LANG')
AND IGB.ISSUE_GROUP_ID = IGID.ISSUE_GROUP_ID(+)
AND IGB.ISSUE_GROUP_TYPE_CODE = IGTYPE.ISSUE_GROUP_TYPE_CODE
AND IGTYPE.LANGUAGE = USERENV('LANG')