VIEW: APPS.IGSFV_INCOME_TAXES

Source

View Text - Preformatted

SELECT '_LA:PIT.TAX_INFO:IGS_LOOKUP_VALUES:TAX_INFO:MEANING', NULL, PIT.TYPE_CODE_ID, PIT.START_DATE, PIT.END_DATE, GEO.GEOGRAPHY_NAME, HZP.PARTY_NUMBER, PIT.TAX_ID, PIT.PERSON_ID, PIT.CREATED_BY, PIT.CREATION_DATE, PIT.LAST_UPDATED_BY, PIT.LAST_UPDATE_DATE FROM IGS_PE_INCOME_TAX_ALL PIT, HZ_PARTIES HZP, HZ_GEOGRAPHIES GEO WHERE PIT.PERSON_ID=HZP.PARTY_ID AND PIT.TAX_INFO = GEO.GEOGRAPHY_TYPE AND PIT.TAX_INFO IN ('STATE', 'COUNTY', 'CITY', 'PROVINCE') AND PIT.TYPE_CODE_ID=GEO.GEOGRAPHY_ID AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') UNION ALL SELECT '_LA:PIT.TAX_INFO:IGS_LOOKUP_VALUES:TAX_INFO:MEANING', PIT.TYPE_CODE, TO_NUMBER(NULL), PIT.START_DATE, PIT.END_DATE, COC.TERRITORY_SHORT_NAME, HZP.PARTY_NUMBER, PIT.TAX_ID, PIT.PERSON_ID, PIT.CREATED_BY, PIT.CREATION_DATE, PIT.LAST_UPDATED_BY, PIT.LAST_UPDATE_DATE FROM IGS_PE_INCOME_TAX_ALL PIT, HZ_PARTIES HZP, FND_TERRITORIES_TL COC WHERE PIT.PERSON_ID=HZP.PARTY_ID AND PIT.TAX_INFO = 'COUNTRY' AND PIT.TYPE_CODE = COC.TERRITORY_CODE AND LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT '_LA:PIT.TAX_INFO:IGS_LOOKUP_VALUES:TAX_INFO:MEANING'
, NULL
, PIT.TYPE_CODE_ID
, PIT.START_DATE
, PIT.END_DATE
, GEO.GEOGRAPHY_NAME
, HZP.PARTY_NUMBER
, PIT.TAX_ID
, PIT.PERSON_ID
, PIT.CREATED_BY
, PIT.CREATION_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE
FROM IGS_PE_INCOME_TAX_ALL PIT
, HZ_PARTIES HZP
, HZ_GEOGRAPHIES GEO
WHERE PIT.PERSON_ID=HZP.PARTY_ID
AND PIT.TAX_INFO = GEO.GEOGRAPHY_TYPE
AND PIT.TAX_INFO IN ('STATE'
, 'COUNTY'
, 'CITY'
, 'PROVINCE')
AND PIT.TYPE_CODE_ID=GEO.GEOGRAPHY_ID
AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') UNION ALL SELECT '_LA:PIT.TAX_INFO:IGS_LOOKUP_VALUES:TAX_INFO:MEANING'
, PIT.TYPE_CODE
, TO_NUMBER(NULL)
, PIT.START_DATE
, PIT.END_DATE
, COC.TERRITORY_SHORT_NAME
, HZP.PARTY_NUMBER
, PIT.TAX_ID
, PIT.PERSON_ID
, PIT.CREATED_BY
, PIT.CREATION_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE
FROM IGS_PE_INCOME_TAX_ALL PIT
, HZ_PARTIES HZP
, FND_TERRITORIES_TL COC
WHERE PIT.PERSON_ID=HZP.PARTY_ID
AND PIT.TAX_INFO = 'COUNTRY'
AND PIT.TYPE_CODE = COC.TERRITORY_CODE
AND LANGUAGE = USERENV('LANG') WITH READ ONLY