VIEW: APPS.IGI_SAP_GROUP_V

Source

View Text - Preformatted

SELECT IGI.ORG_ID, HR.NAME, IGI.GROUP_ID, IGI.GROUP_NAME, IGI.CREATION_DATE, IGI.CREATED_BY, IGI.LAST_UPDATE_DATE,IGI.LAST_UPDATED_BY, IGI.LAST_UPDATE_LOGIN, IGI.ROWID FROM IGI_SAP_GROUP IGI, HR_OPERATING_UNITS HR, igi_gcc_inst_options_all gcc WHERE IGI.ORG_ID = HR.ORGANIZATION_ID and gcc.org_id = igi.org_id and gcc.option_name = 'SIA' and gcc.status_flag = 'Y'

View Text - HTML Formatted

SELECT IGI.ORG_ID
, HR.NAME
, IGI.GROUP_ID
, IGI.GROUP_NAME
, IGI.CREATION_DATE
, IGI.CREATED_BY
, IGI.LAST_UPDATE_DATE
, IGI.LAST_UPDATED_BY
, IGI.LAST_UPDATE_LOGIN
, IGI.ROWID
FROM IGI_SAP_GROUP IGI
, HR_OPERATING_UNITS HR
, IGI_GCC_INST_OPTIONS_ALL GCC
WHERE IGI.ORG_ID = HR.ORGANIZATION_ID
AND GCC.ORG_ID = IGI.ORG_ID
AND GCC.OPTION_NAME = 'SIA'
AND GCC.STATUS_FLAG = 'Y'