VIEW: APPS.ZX_TAX_CONDITION_LINES_V

Source

View Text - Preformatted

SELECT CLINE.ROWID, 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 AR_TAX_CONDITION_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'
   

View Text - HTML Formatted

SELECT CLINE.ROWID
, 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 AR_TAX_CONDITION_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'