eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGS_PE_INCOME_TAX_V

Source

View Text - Preformatted


SELECT IT.ROWID ROW_ID, IT.TAX_ID, IT.PERSON_ID, IT.TAX_INFO, LK.MEANING, NULL, IT.TYPE_CODE_ID, IT.START_DATE, IT.END_DATE, GEO.GEOGRAPHY_NAME LEVEL_DESC, IT.CREATED_BY, IT.CREATION_DATE, IT.LAST_UPDATED_BY, IT.LAST_UPDATE_DATE, IT.LAST_UPDATE_LOGIN FROM IGS_PE_INCOME_TAX_ALL IT, IGS_LOOKUP_VALUES LK, HZ_GEOGRAPHIES GEO WHERE IT.TAX_INFO = GEO.GEOGRAPHY_TYPE AND IT.TAX_INFO IN ('STATE', 'COUNTY', 'CITY', 'PROVINCE') AND LK.LOOKUP_TYPE = 'TAX_INFO' AND LK.LOOKUP_CODE = IT.TAX_INFO AND IT.TYPE_CODE_ID = GEO.GEOGRAPHY_ID AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') UNION ALL SELECT IT.ROWID ROW_ID, IT.TAX_ID, IT.PERSON_ID, IT.TAX_INFO, LK.MEANING, IT.TYPE_CODE, TO_NUMBER(NULL), IT.START_DATE, IT.END_DATE, COC.TERRITORY_SHORT_NAME LEVEL_DESC, IT.CREATED_BY, IT.CREATION_DATE, IT.LAST_UPDATED_BY, IT.LAST_UPDATE_DATE, IT.LAST_UPDATE_LOGIN FROM IGS_PE_INCOME_TAX_ALL IT, IGS_LOOKUP_VALUES LK, FND_TERRITORIES_VL COC WHERE IT.TAX_INFO = 'COUNTRY' AND LK.LOOKUP_TYPE = 'TAX_INFO' AND LK.LOOKUP_CODE = IT.TAX_INFO AND IT.TYPE_CODE = COC.TERRITORY_CODE

View Text - HTML Formatted

SELECT IT.ROWID ROW_ID
, IT.TAX_ID
, IT.PERSON_ID
, IT.TAX_INFO
, LK.MEANING
, NULL
, IT.TYPE_CODE_ID
, IT.START_DATE
, IT.END_DATE
, GEO.GEOGRAPHY_NAME LEVEL_DESC
, IT.CREATED_BY
, IT.CREATION_DATE
, IT.LAST_UPDATED_BY
, IT.LAST_UPDATE_DATE
, IT.LAST_UPDATE_LOGIN
FROM IGS_PE_INCOME_TAX_ALL IT
, IGS_LOOKUP_VALUES LK
, HZ_GEOGRAPHIES GEO
WHERE IT.TAX_INFO = GEO.GEOGRAPHY_TYPE
AND IT.TAX_INFO IN ('STATE'
, 'COUNTY'
, 'CITY'
, 'PROVINCE')
AND LK.LOOKUP_TYPE = 'TAX_INFO'
AND LK.LOOKUP_CODE = IT.TAX_INFO
AND IT.TYPE_CODE_ID = GEO.GEOGRAPHY_ID
AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') UNION ALL SELECT IT.ROWID ROW_ID
, IT.TAX_ID
, IT.PERSON_ID
, IT.TAX_INFO
, LK.MEANING
, IT.TYPE_CODE
, TO_NUMBER(NULL)
, IT.START_DATE
, IT.END_DATE
, COC.TERRITORY_SHORT_NAME LEVEL_DESC
, IT.CREATED_BY
, IT.CREATION_DATE
, IT.LAST_UPDATED_BY
, IT.LAST_UPDATE_DATE
, IT.LAST_UPDATE_LOGIN
FROM IGS_PE_INCOME_TAX_ALL IT
, IGS_LOOKUP_VALUES LK
, FND_TERRITORIES_VL COC
WHERE IT.TAX_INFO = 'COUNTRY'
AND LK.LOOKUP_TYPE = 'TAX_INFO'
AND LK.LOOKUP_CODE = IT.TAX_INFO
AND IT.TYPE_CODE = COC.TERRITORY_CODE