[Home] [Help]
View: IGS_PE_INCOME_TAX_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
Columns
| Name |
| ROW_ID |
| TAX_ID |
| PERSON_ID |
| TAX_INFO |
| MEANING |
| TYPE_CODE |
| TYPE_CODE_ID |
| START_DATE |
| END_DATE |
| LEVEL_DESC |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |