1. Tables and Views for Financials
  2. ZX_TAX_CLASSIFICATIONS_V

ZX_TAX_CLASSIFICATIONS_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

SET_ID

MEANING

DESCRIPTION

LOOKUP_CODE

LOOKUP_TYPE

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

Query

SQL_Statement

SELECT

LKV.set_id SET_ID,

LKV.meaning MEANING,

LKV.description DESCRIPTION,

LKV.lookup_code LOOKUP_CODE,

LKV.lookup_type LOOKUP_TYPE,

LKV.enabled_flag ENABLED_FLAG,

LKV.start_date_active START_DATE_ACTIVE,

LKV.end_date_active END_DATE_ACTIVE

FROM FND_LOOKUP_VALUES_VL LKV

WHERE LKV.LOOKUP_TYPE IN ( 'ZX_OUTPUT_CLASSIFICATIONS',

'ZX_INPUT_CLASSIFICATIONS',

'ZX_WEB_EXP_TAX_CLASSIFICATIONS')

AND LKV.enabled_flag = 'Y'

AND LKV.view_application_id = 2