VIEW: APPS.ZX_SCO_RATES_B_V

Source

View Text - Preformatted

select
     a.ROWID ROW_ID,
     a.TAX_RATE_ID,
     a.TAX_RATE_CODE,
     a.CONTENT_OWNER_ID,
     a.EFFECTIVE_FROM,
     a.EFFECTIVE_TO,
     a.TAX_REGIME_CODE,
     a.TAX,
     a.TAX_STATUS_CODE,
     a.SCHEDULE_BASED_RATE_FLAG,
     a.RATE_TYPE_CODE,
     a.PERCENTAGE_RATE,
     a.QUANTITY_RATE,
     a.UOM_CODE,
     a.TAX_JURISDICTION_CODE,
     a.RECOVERY_TYPE_CODE,
     a.ACTIVE_FLAG,
     a.DEFAULT_RATE_FLAG,
     a.DEFAULT_FLG_EFFECTIVE_FROM,
     a.DEFAULT_FLG_EFFECTIVE_TO,
     a.DEFAULT_REC_TYPE_CODE,
     a.DEFAULT_REC_RATE_CODE,
     a.OFFSET_TAX,
     a.OFFSET_STATUS_CODE,
     a.OFFSET_TAX_RATE_CODE,
     a.RECOVERY_RULE_CODE,
     a.DEF_REC_SETTLEMENT_OPTION_CODE,
     a.VAT_TRANSACTION_TYPE_CODE,
     a.ADJ_FOR_ADHOC_AMT_CODE,
     a.ALLOW_ADHOC_TAX_RATE_FLAG,
     a.TAX_CLASS,
     a.SOURCE_ID,
     a.TAXABLE_BASIS_FORMULA_CODE,
     a.INCLUSIVE_TAX_FLAG,
     a.TAX_INCLUSIVE_OVERRIDE_FLAG,
     a.ALLOW_EXEMPTIONS_FLAG,
     a.ALLOW_EXCEPTIONS_FLAG,
     a.OBJECT_VERSION_NUMBER,
     a.RECORD_TYPE_CODE,
     a.CREATED_BY,
     a.CREATION_DATE,
     a.LAST_UPDATED_BY,
     a.LAST_UPDATE_DATE,
     a.LAST_UPDATE_LOGIN,
     a.REQUEST_ID,
     a.PROGRAM_APPLICATION_ID,
     a.PROGRAM_ID,
     a.PROGRAM_LOGIN_ID,
     a.ATTRIBUTE1,
     a.ATTRIBUTE2,
     a.ATTRIBUTE3,
     a.ATTRIBUTE4,
     a.ATTRIBUTE5,
     a.ATTRIBUTE6,
     a.ATTRIBUTE7,
     a.ATTRIBUTE8,
     a.ATTRIBUTE9,
     a.ATTRIBUTE10,
     a.ATTRIBUTE11,
     a.ATTRIBUTE12,
     a.ATTRIBUTE13,
     a.ATTRIBUTE14,
     a.ATTRIBUTE15,
     a.ATTRIBUTE_CATEGORY,
     sd.view_options_code subscription_level_code,
     sd.first_pty_org_id SDCO_ID,
     sd.effective_from SDEFF_FROM,
     sd.effective_to SDEFF_TO
   from ZX_RATES_B a, zx_subscription_details sd
   where
       a.tax_regime_code = sd.tax_regime_code
   and a.content_owner_id = sd.parent_first_pty_org_id
   and sd.view_options_code <> 'VFD'
   ORDER BY sd.VIEW_OPTIONS_CODE

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.TAX_RATE_ID
, A.TAX_RATE_CODE
, A.CONTENT_OWNER_ID
, A.EFFECTIVE_FROM
, A.EFFECTIVE_TO
, A.TAX_REGIME_CODE
, A.TAX
, A.TAX_STATUS_CODE
, A.SCHEDULE_BASED_RATE_FLAG
, A.RATE_TYPE_CODE
, A.PERCENTAGE_RATE
, A.QUANTITY_RATE
, A.UOM_CODE
, A.TAX_JURISDICTION_CODE
, A.RECOVERY_TYPE_CODE
, A.ACTIVE_FLAG
, A.DEFAULT_RATE_FLAG
, A.DEFAULT_FLG_EFFECTIVE_FROM
, A.DEFAULT_FLG_EFFECTIVE_TO
, A.DEFAULT_REC_TYPE_CODE
, A.DEFAULT_REC_RATE_CODE
, A.OFFSET_TAX
, A.OFFSET_STATUS_CODE
, A.OFFSET_TAX_RATE_CODE
, A.RECOVERY_RULE_CODE
, A.DEF_REC_SETTLEMENT_OPTION_CODE
, A.VAT_TRANSACTION_TYPE_CODE
, A.ADJ_FOR_ADHOC_AMT_CODE
, A.ALLOW_ADHOC_TAX_RATE_FLAG
, A.TAX_CLASS
, A.SOURCE_ID
, A.TAXABLE_BASIS_FORMULA_CODE
, A.INCLUSIVE_TAX_FLAG
, A.TAX_INCLUSIVE_OVERRIDE_FLAG
, A.ALLOW_EXEMPTIONS_FLAG
, A.ALLOW_EXCEPTIONS_FLAG
, A.OBJECT_VERSION_NUMBER
, A.RECORD_TYPE_CODE
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_LOGIN_ID
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE_CATEGORY
, SD.VIEW_OPTIONS_CODE SUBSCRIPTION_LEVEL_CODE
, SD.FIRST_PTY_ORG_ID SDCO_ID
, SD.EFFECTIVE_FROM SDEFF_FROM
, SD.EFFECTIVE_TO SDEFF_TO
FROM ZX_RATES_B A
, ZX_SUBSCRIPTION_DETAILS SD WHERE A.TAX_REGIME_CODE = SD.TAX_REGIME_CODE
AND A.CONTENT_OWNER_ID = SD.PARENT_FIRST_PTY_ORG_ID
AND SD.VIEW_OPTIONS_CODE <> 'VFD' ORDER BY SD.VIEW_OPTIONS_CODE