VIEW: APPS.ZX_TAX_CONDITION_ACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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