Product: | AS - Sales Foundation |
---|---|
Description: | THIS VIEW SHOWS ISSUE GROUP DETAILS |
Implementation/DBA Data: | APPS.AS_ISSUE_GROUP_DETAILS_V |
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')