DBA Data[Home] [Help]

VIEW: APPS.IGI_GCC_LEDGER_V

Source

View Text - Preformatted

SELECT hr.set_of_books_id,hr.name from igi_gcc_inst_options gcc, hr_operating_units hr WHERE gcc.org_id = hr.organization_id and gcc.option_name = 'SIA'
View Text - HTML Formatted

SELECT HR.SET_OF_BOOKS_ID
, HR.NAME
FROM IGI_GCC_INST_OPTIONS GCC
, HR_OPERATING_UNITS HR
WHERE GCC.ORG_ID = HR.ORGANIZATION_ID
AND GCC.OPTION_NAME = 'SIA'