SELECT DISTINCT
ZRB.ROWID AS ROW_ID,
ZRB.TAX_RATE_ID,
ZRB.TAX_RATE_CODE,
ZSD.FIRST_PTY_ORG_ID 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.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,
ZSD.VIEW_OPTIONS_CODE
FROM ZX_RATES_B ZRB,
ZX_RATES_TL ZRT,
ZX_SUBSCRIPTION_DETAILS ZSD,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
WHERE ZRT.TAX_RATE_ID = ZRB.TAX_RATE_ID
AND ZRT.LANGUAGE = USERENV('LANG')
AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID
AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID
AND ZSD.VIEW_OPTIONS_CODE IN ('VFC','VFR')
AND ((ZSD.FIRST_PTY_ORG_ID = -99
AND FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'
) OR (ZSD.FIRST_PTY_ORG_ID <> -99))
ORDER BY ZSD.VIEW_OPTIONS_CODE
SELECT DISTINCT
ZRB.ROWID AS ROW_ID
,
ZRB.TAX_RATE_ID
,
ZRB.TAX_RATE_CODE
,
ZSD.FIRST_PTY_ORG_ID 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.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
,
ZSD.VIEW_OPTIONS_CODE
FROM ZX_RATES_B ZRB
,
ZX_RATES_TL ZRT
,
ZX_SUBSCRIPTION_DETAILS ZSD
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
WHERE ZRT.TAX_RATE_ID = ZRB.TAX_RATE_ID
AND ZRT.LANGUAGE = USERENV('LANG')
AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID
AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID
AND ZSD.VIEW_OPTIONS_CODE IN ('VFC'
, 'VFR')
AND ((ZSD.FIRST_PTY_ORG_ID = -99
AND FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'
) OR (ZSD.FIRST_PTY_ORG_ID <> -99))
ORDER BY ZSD.VIEW_OPTIONS_CODE
|
|
|