ZX_MCO_EO_EXEMPTIONS_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

TAX_EXEMPTION_ID EXEMPTION_TYPE_CODE EXEMPTION_STATUS_CODE TAX_REGIME_CODE TAX_STATUS_CODE TAX TAX_RATE_CODE EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE ISSUING_TAX_AUTHORITY_ID EFFECTIVE_FROM EFFECTIVE_TO CONTENT_OWNER_ID PRODUCT_ID INVENTORY_ORG_ID RATE_MODIFIER TAX_JURISDICTION_ID DET_FACTOR_TEMPL_CODE RECORD_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY APPLY_TO_LOWER_LEVELS_FLAG OBJECT_VERSION_NUMBER PARTY_TAX_PROFILE_ID CUST_ACCOUNT_ID SITE_USE_ID DUPLICATE_EXEMPTION CONTENT_OWNER_NAME ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5

Query

SQL_Statement

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_APP_NAME, ZE.PROGRAM_NAME, 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, ZE.ATTRIBUTE_NUMBER1, ZE.ATTRIBUTE_NUMBER2, ZE.ATTRIBUTE_NUMBER3, ZE.ATTRIBUTE_NUMBER4, ZE.ATTRIBUTE_NUMBER5, ZE.ATTRIBUTE_DATE1, ZE.ATTRIBUTE_DATE2, ZE.ATTRIBUTE_DATE3, ZE.ATTRIBUTE_DATE4, ZE.ATTRIBUTE_DATE5 FROM ZX_EXEMPTIONS ZE, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV WHERE ZFPOMV.PARTY_TAX_PROFILE_ID = ZE.CONTENT_OWNER_ID