1. Tables and Views for Financials
  2. ZX_TAX_CONDITION_ACTIONS_V

ZX_TAX_CONDITION_ACTIONS_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

TAX_CONDITION_ACTION_ID

CREATED_BY

TAX_CONDITION_ID

CREATION_DATE

TAX_CONDITION_ACTION_TYPE

ACTION_TYPE_NAME

ACTION_DISPLAY_ORDER

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

TAX_CONDITION_ACTION_CODE

ACTION_NAME

TAX_CONDITION_ACTION_VALUE

ACTION_VALUE_NAME

CONTENT_OWNER_ID

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

Query

SQL_Statement

SELECT CACTION.ROWID ROW_ID,

CACTION.TAX_CONDITION_ACTION_ID,

CACTION.CREATED_BY,

CACTION.TAX_CONDITION_ID,

CACTION.CREATION_DATE,

CACTION.TAX_CONDITION_ACTION_TYPE,

AT.MEANING ACTION_TYPE_NAME,

CACTION.DISPLAY_ORDER ACTION_DISPLAY_ORDER,

CACTION.LAST_UPDATED_BY,

CACTION.LAST_UPDATE_DATE,

CACTION.LAST_UPDATE_LOGIN,

CACTION.TAX_CONDITION_ACTION_CODE,

AC.MEANING ACTION_NAME,

CACTION.TAX_CONDITION_ACTION_VALUE,

CACTION.TAX_CONDITION_ACTION_VALUE ACTION_VALUE_NAME,

CACTION.ORG_ID CONTENT_OWNER_ID,

CACTION.ATTRIBUTE_CATEGORY,

CACTION.ATTRIBUTE1,

CACTION.ATTRIBUTE2,

CACTION.ATTRIBUTE3,

CACTION.ATTRIBUTE4,

CACTION.ATTRIBUTE5,

CACTION.ATTRIBUTE6,

CACTION.ATTRIBUTE7,

CACTION.ATTRIBUTE8,

CACTION.ATTRIBUTE9,

CACTION.ATTRIBUTE10,

CACTION.ATTRIBUTE11,

CACTION.ATTRIBUTE12,

CACTION.ATTRIBUTE13,

CACTION.ATTRIBUTE14,

CACTION.ATTRIBUTE15,

CACTION.GLOBAL_ATTRIBUTE_CATEGORY,

CACTION.GLOBAL_ATTRIBUTE1,

CACTION.GLOBAL_ATTRIBUTE2,

CACTION.GLOBAL_ATTRIBUTE3,

CACTION.GLOBAL_ATTRIBUTE4,

CACTION.GLOBAL_ATTRIBUTE5,

CACTION.GLOBAL_ATTRIBUTE6,

CACTION.GLOBAL_ATTRIBUTE7,

CACTION.GLOBAL_ATTRIBUTE8,

CACTION.GLOBAL_ATTRIBUTE9,

CACTION.GLOBAL_ATTRIBUTE10,

CACTION.GLOBAL_ATTRIBUTE11,

CACTION.GLOBAL_ATTRIBUTE12,

CACTION.GLOBAL_ATTRIBUTE13,

CACTION.GLOBAL_ATTRIBUTE14,

CACTION.GLOBAL_ATTRIBUTE15,

CACTION.GLOBAL_ATTRIBUTE16,

CACTION.GLOBAL_ATTRIBUTE17,

CACTION.GLOBAL_ATTRIBUTE18,

CACTION.GLOBAL_ATTRIBUTE19,

CACTION.GLOBAL_ATTRIBUTE20

FROM ZX_AR_COND_ACTIONS_ALL CACTION,

ZX_CEC_LOOKUPS AT,

ZX_CEC_LOOKUPS AC

WHERE CACTION.TAX_CONDITION_ACTION_TYPE = AT.LOOKUP_CODE

AND AT.LOOKUP_TYPE = 'TAX_CONDITION_ACTION_TYPE'

AND CACTION.TAX_CONDITION_ACTION_CODE = AC.LOOKUP_CODE

AND AC.LOOKUP_TYPE = 'TAX_CONDITION_ACTION_CODE'