1. Tables and Views for Financials
  2. ZX_WHT_TAX_CLASSIFICATION_V

ZX_WHT_TAX_CLASSIFICATION_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

GROUP_ID

NAME

DESCRIPTION

INACTIVE_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT DISTINCT

idtc.tax_rate_code_id GROUP_ID,

fnd.lookup_code NAME,

fnd.meaning DESCRIPTION,

idtc.effective_to INACTIVE_DATE,

idtc.LAST_UPDATE_DATE,

idtc.LAST_UPDATED_BY,

idtc.LAST_UPDATE_LOGIN,

idtc.CREATION_DATE,

idtc.CREATED_BY,

1 OBJECT_VERSION_NUMBER

FROM FND_LOOKUP_VALUES_VL fnd,

ZX_ID_TCC_MAPPING_ALL idtc

WHERE fnd.lookup_type = 'ZX_WHT_TAX_CLASSIFICATION_CODE'

AND fnd.lookup_code = idtc.tax_classification_code

AND idtc.source IN ('USER_DEFINED', 'AP', 'FUSION_RI_UPLOAD')