[Home] [Help]
View: ZX_MCO_EO_EXEMPTIONS_V
View Text
SELECT
ZE.TAX_EXEMPTION_ID
,
ZE.EXEMPTION_TYPE_CODE
,
ZE.EXEMPTION_STATUS_CODE
,
ZE.TAX_REGIME_CODE
,
ZE.TAX_STATUS_CODE
,
ZE.TAX
,
ZE.TAX_RATE_CODE
,
ZE.EXEMPT_CERTIFICATE_NUMBER
,
ZE.EXEMPT_REASON_CODE
,
ZE.ISSUING_TAX_AUTHORITY_ID
,
ZE.EFFECTIVE_FROM
,
ZE.EFFECTIVE_TO
,
ZE.CONTENT_OWNER_ID
,
ZE.PRODUCT_ID
,
ZE.INVENTORY_ORG_ID
,
ZE.RATE_MODIFIER
,
ZE.TAX_JURISDICTION_ID
,
ZE.DET_FACTOR_TEMPL_CODE
,
ZE.RECORD_TYPE_CODE
,
ZE.CREATED_BY
,
ZE.CREATION_DATE
,
ZE.LAST_UPDATED_BY
,
ZE.LAST_UPDATE_DATE
,
ZE.LAST_UPDATE_LOGIN
,
ZE.REQUEST_ID
,
ZE.PROGRAM_APPLICATION_ID
,
ZE.PROGRAM_ID
,
ZE.PROGRAM_LOGIN_ID
,
ZE.ATTRIBUTE1
,
ZE.ATTRIBUTE2
,
ZE.ATTRIBUTE3
,
ZE.ATTRIBUTE4
,
ZE.ATTRIBUTE5
,
ZE.ATTRIBUTE6
,
ZE.ATTRIBUTE7
,
ZE.ATTRIBUTE8
,
ZE.ATTRIBUTE9
,
ZE.ATTRIBUTE10
,
ZE.ATTRIBUTE11
,
ZE.ATTRIBUTE12
,
ZE.ATTRIBUTE13
,
ZE.ATTRIBUTE14
,
ZE.ATTRIBUTE15
,
ZE.ATTRIBUTE_CATEGORY
,
ZE.APPLY_TO_LOWER_LEVELS_FLAG
,
ZE.OBJECT_VERSION_NUMBER
,
ZE.PARTY_TAX_PROFILE_ID
,
ZE.CUST_ACCOUNT_ID
,
ZE.SITE_USE_ID
,
ZE.DUPLICATE_EXEMPTION
,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
FROM ZX_EXEMPTIONS ZE
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
WHERE ZFPOMV.PARTY_TAX_PROFILE_ID = ZE.CONTENT_OWNER_ID