eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ZX_TAX_CONDITION_LINES_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_TAX_CONDITION_LINES_V

View Text

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'