VIEW: APPS.ZX_MCO_EO_RATES_V

Source

View Text - Preformatted

(SELECT  ZRB.ROWID AS ROW_ID                    ,
        ZRB.TAX_RATE_ID                        ,
        ZRB.TAX_RATE_CODE                      ,
        ZRB.CONTENT_OWNER_ID                   ,
        ZRB.EFFECTIVE_FROM                     ,
        ZRB.EFFECTIVE_TO                       ,
        ZRB.TAX_REGIME_CODE                    ,
        ZRB.TAX                                ,
        ZRB.TAX_STATUS_CODE                    ,
        ZRB.SCHEDULE_BASED_RATE_FLAG           ,
        ZRB.RATE_TYPE_CODE                     ,
        ZRB.PERCENTAGE_RATE                    ,
        ZRB.QUANTITY_RATE                      ,
        ZRB.UOM_CODE                           ,
        ZRB.TAX_JURISDICTION_CODE              ,
        ZRB.RECOVERY_TYPE_CODE                 ,
        ZRB.ACTIVE_FLAG                        ,
        ZRB.DEFAULT_RATE_FLAG                  ,
        ZRB.DEFAULT_FLG_EFFECTIVE_FROM         ,
        ZRB.DEFAULT_FLG_EFFECTIVE_TO           ,
        ZRB.DEFAULT_REC_TYPE_CODE              ,
        ZRB.DEFAULT_REC_RATE_CODE              ,
        ZRB.OFFSET_TAX                         ,
        ZRB.OFFSET_STATUS_CODE                 ,
        ZRB.OFFSET_TAX_RATE_CODE               ,
        ZRB.RECOVERY_RULE_CODE                 ,
        ZRB.DEF_REC_SETTLEMENT_OPTION_CODE     ,
        ZRB.VAT_TRANSACTION_TYPE_CODE          ,
        ZRB.ADJ_FOR_ADHOC_AMT_CODE             ,
        ZRB.ALLOW_ADHOC_TAX_RATE_FLAG          ,
        ZRB.TAX_CLASS                          ,
        ZRB.SOURCE_ID                          ,
        ZRB.TAXABLE_BASIS_FORMULA_CODE         ,
        ZRB.INCLUSIVE_TAX_FLAG                 ,
        ZRB.TAX_INCLUSIVE_OVERRIDE_FLAG        ,
        ZRB.ALLOW_EXEMPTIONS_FLAG              ,
        ZRB.ALLOW_EXCEPTIONS_FLAG              ,
        ZRT.DESCRIPTION                        ,
        ZRB.OBJECT_VERSION_NUMBER              ,
        ZRB.RECORD_TYPE_CODE                   ,
        ZRB.CREATED_BY                         ,
        ZRB.CREATION_DATE                      ,
        ZRB.LAST_UPDATED_BY                    ,
        ZRB.LAST_UPDATE_DATE                   ,
        ZRB.LAST_UPDATE_LOGIN                  ,
        ZRB.REQUEST_ID                         ,
        ZRB.PROGRAM_APPLICATION_ID             ,
        ZRB.PROGRAM_ID                         ,
        ZRB.PROGRAM_LOGIN_ID                   ,
        ZRB.ATTRIBUTE1                         ,
        ZRB.ATTRIBUTE2                         ,
        ZRB.ATTRIBUTE3                         ,
        ZRB.ATTRIBUTE4                         ,
        ZRB.ATTRIBUTE5                         ,
        ZRB.ATTRIBUTE6                         ,
        ZRB.ATTRIBUTE7                         ,
        ZRB.ATTRIBUTE8                         ,
        ZRB.ATTRIBUTE9                         ,
        ZRB.ATTRIBUTE10                        ,
        ZRB.ATTRIBUTE11                        ,
        ZRB.ATTRIBUTE12                        ,
        ZRB.ATTRIBUTE13                        ,
        ZRB.ATTRIBUTE14                        ,
        ZRB.ATTRIBUTE15                        ,
        ZRB.ATTRIBUTE_CATEGORY                 ,
        ZRT.TAX_RATE_NAME                      ,
        ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME,
        ZMCAV.UPDATE_ACCESS                    ,
        ZMCAV.DUPLICATE_ACCESS
FROM    ZX_RATES_B ZRB                   ,
        ZX_RATES_TL ZRT                  ,
        ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV,
        ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE   ZRT.TAX_RATE_ID               = ZRB.TAX_RATE_ID
    AND ZRT.LANGUAGE                  = USERENV('LANG')
    AND ZFPOMV.PARTY_TAX_PROFILE_ID   = ZRB.CONTENT_OWNER_ID
    AND ZMCAV.TAX_REGIME_CODE         = ZRB.TAX_REGIME_CODE
    AND ZMCAV.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID
)

View Text - HTML Formatted

(SELECT ZRB.ROWID AS ROW_ID
, ZRB.TAX_RATE_ID
, ZRB.TAX_RATE_CODE
, ZRB.CONTENT_OWNER_ID
, ZRB.EFFECTIVE_FROM
, ZRB.EFFECTIVE_TO
, ZRB.TAX_REGIME_CODE
, ZRB.TAX
, ZRB.TAX_STATUS_CODE
, ZRB.SCHEDULE_BASED_RATE_FLAG
, ZRB.RATE_TYPE_CODE
, ZRB.PERCENTAGE_RATE
, ZRB.QUANTITY_RATE
, ZRB.UOM_CODE
, ZRB.TAX_JURISDICTION_CODE
, ZRB.RECOVERY_TYPE_CODE
, ZRB.ACTIVE_FLAG
, ZRB.DEFAULT_RATE_FLAG
, ZRB.DEFAULT_FLG_EFFECTIVE_FROM
, ZRB.DEFAULT_FLG_EFFECTIVE_TO
, ZRB.DEFAULT_REC_TYPE_CODE
, ZRB.DEFAULT_REC_RATE_CODE
, ZRB.OFFSET_TAX
, ZRB.OFFSET_STATUS_CODE
, ZRB.OFFSET_TAX_RATE_CODE
, ZRB.RECOVERY_RULE_CODE
, ZRB.DEF_REC_SETTLEMENT_OPTION_CODE
, ZRB.VAT_TRANSACTION_TYPE_CODE
, ZRB.ADJ_FOR_ADHOC_AMT_CODE
, ZRB.ALLOW_ADHOC_TAX_RATE_FLAG
, ZRB.TAX_CLASS
, ZRB.SOURCE_ID
, ZRB.TAXABLE_BASIS_FORMULA_CODE
, ZRB.INCLUSIVE_TAX_FLAG
, ZRB.TAX_INCLUSIVE_OVERRIDE_FLAG
, ZRB.ALLOW_EXEMPTIONS_FLAG
, ZRB.ALLOW_EXCEPTIONS_FLAG
, ZRT.DESCRIPTION
, ZRB.OBJECT_VERSION_NUMBER
, ZRB.RECORD_TYPE_CODE
, ZRB.CREATED_BY
, ZRB.CREATION_DATE
, ZRB.LAST_UPDATED_BY
, ZRB.LAST_UPDATE_DATE
, ZRB.LAST_UPDATE_LOGIN
, ZRB.REQUEST_ID
, ZRB.PROGRAM_APPLICATION_ID
, ZRB.PROGRAM_ID
, ZRB.PROGRAM_LOGIN_ID
, ZRB.ATTRIBUTE1
, ZRB.ATTRIBUTE2
, ZRB.ATTRIBUTE3
, ZRB.ATTRIBUTE4
, ZRB.ATTRIBUTE5
, ZRB.ATTRIBUTE6
, ZRB.ATTRIBUTE7
, ZRB.ATTRIBUTE8
, ZRB.ATTRIBUTE9
, ZRB.ATTRIBUTE10
, ZRB.ATTRIBUTE11
, ZRB.ATTRIBUTE12
, ZRB.ATTRIBUTE13
, ZRB.ATTRIBUTE14
, ZRB.ATTRIBUTE15
, ZRB.ATTRIBUTE_CATEGORY
, ZRT.TAX_RATE_NAME
, ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
, ZMCAV.UPDATE_ACCESS
, ZMCAV.DUPLICATE_ACCESS FROM ZX_RATES_B ZRB
, ZX_RATES_TL ZRT
, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
, ZX_MCO_CHECK_ACCESS_V ZMCAV WHERE ZRT.TAX_RATE_ID = ZRB.TAX_RATE_ID
AND ZRT.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID )