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
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
|
|
|