1. Tables and Views for Financials
  2. ZX_TAX_CONDITION_LINES_V

ZX_TAX_CONDITION_LINES_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

TAX_CONDITION_LINE_ID

CREATED_BY

TAX_CONDITION_ID

CREATION_DATE

LINE_DISPLAY_ORDER

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

TAX_CONDITION_CLAUSE

LINE_CLAUSE_NAME

TAX_CONDITION_ENTITY

LINE_ENTITY_NAME

TAX_CONDITION_OPERATOR

LINE_OPERATOR_NAME

TAX_CONDITION_FIELD

LINE_FIELD_NAME

TAX_CONDITION_VALUE

LINE_VALUE_NAME

TAX_CONDITION_EXPR

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 CLINE.ROWID ROW_ID,

CLINE.TAX_CONDITION_LINE_ID,

CLINE.CREATED_BY,

CLINE.TAX_CONDITION_ID,

CLINE.CREATION_DATE,

CLINE.DISPLAY_ORDER LINE_DISPLAY_ORDER,

CLINE.LAST_UPDATED_BY,

CLINE.LAST_UPDATE_DATE,

CLINE.LAST_UPDATE_LOGIN,

CLINE.TAX_CONDITION_CLAUSE,

CL.MEANING LINE_CLAUSE_NAME,

CLINE.TAX_CONDITION_ENTITY,

EN.MEANING LINE_ENTITY_NAME,

CLINE.TAX_CONDITION_OPERATOR,

OP.MEANING LINE_OPERATOR_NAME,

CLINE.TAX_CONDITION_FIELD,

FI.MEANING LINE_FIELD_NAME,

CLINE.TAX_CONDITION_VALUE,

decode (cline.tax_condition_operator, 'NOT_FOUND', NULL, CLINE.TAX_CONDITION_VALUE ) LINE_VALUE_NAME,

CLINE.TAX_CONDITION_EXPR,

CLINE.ORG_ID CONTENT_OWNER_ID,

CLINE.ATTRIBUTE_CATEGORY,

CLINE.ATTRIBUTE1,

CLINE.ATTRIBUTE2,

CLINE.ATTRIBUTE3,

CLINE.ATTRIBUTE4,

CLINE.ATTRIBUTE5,

CLINE.ATTRIBUTE6,

CLINE.ATTRIBUTE7,

CLINE.ATTRIBUTE8,

CLINE.ATTRIBUTE9,

CLINE.ATTRIBUTE10,

CLINE.ATTRIBUTE11,

CLINE.ATTRIBUTE12,

CLINE.ATTRIBUTE13,

CLINE.ATTRIBUTE14,

CLINE.ATTRIBUTE15,

CLINE.GLOBAL_ATTRIBUTE_CATEGORY,

CLINE.GLOBAL_ATTRIBUTE1,

CLINE.GLOBAL_ATTRIBUTE2,

CLINE.GLOBAL_ATTRIBUTE3,

CLINE.GLOBAL_ATTRIBUTE4,

CLINE.GLOBAL_ATTRIBUTE5,

CLINE.GLOBAL_ATTRIBUTE6,

CLINE.GLOBAL_ATTRIBUTE7,

CLINE.GLOBAL_ATTRIBUTE8,

CLINE.GLOBAL_ATTRIBUTE9,

CLINE.GLOBAL_ATTRIBUTE10,

CLINE.GLOBAL_ATTRIBUTE11,

CLINE.GLOBAL_ATTRIBUTE12,

CLINE.GLOBAL_ATTRIBUTE13,

CLINE.GLOBAL_ATTRIBUTE14,

CLINE.GLOBAL_ATTRIBUTE15,

CLINE.GLOBAL_ATTRIBUTE16,

CLINE.GLOBAL_ATTRIBUTE17,

CLINE.GLOBAL_ATTRIBUTE18,

CLINE.GLOBAL_ATTRIBUTE19,

CLINE.GLOBAL_ATTRIBUTE20

FROM ZX_AR_TAX_COND_LINES_ALL CLINE,

ZX_CEC_LOOKUPS CL,

ZX_CEC_LOOKUPS EN,

ZX_CEC_LOOKUPS OP,

ZX_CEC_LOOKUPS FI

WHERE CLINE.TAX_CONDITION_CLAUSE = CL.LOOKUP_CODE

AND CL.LOOKUP_TYPE = 'TAX_CONDITION_CLAUSE'

AND CLINE.TAX_CONDITION_ENTITY = EN.LOOKUP_CODE

AND EN.LOOKUP_TYPE = 'TAX_CONDITION_ENTITY'

AND CLINE.TAX_CONDITION_OPERATOR = OP.LOOKUP_CODE

AND OP.LOOKUP_TYPE IN ( 'TAX_CONDITION_OPERATOR', 'TAX_ACTION_OPERATOR')

AND CLINE.TAX_CONDITION_FIELD = FI.LOOKUP_CODE AND FI.LOOKUP_TYPE = 'TAX_CONDITION_FIELD'