[Home] [Help] [Dependency Information]

VIEW: APPS.ZX_SCO_RATES_V

Object Details

Object Name:	ZX_SCO_RATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.ZX_SCO_RATES_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      CONTENT_OWNER_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      TAX_REGIME_CODE
,      TAX
,      TAX_STATUS_CODE
,      SCHEDULE_BASED_RATE_FLAG
,      RATE_TYPE_CODE
,      PERCENTAGE_RATE
,      QUANTITY_RATE
,      UOM_CODE
,      TAX_JURISDICTION_CODE
,      RECOVERY_TYPE_CODE
,      ACTIVE_FLAG
,      DEFAULT_RATE_FLAG
,      DEFAULT_FLG_EFFECTIVE_FROM
,      DEFAULT_FLG_EFFECTIVE_TO
,      DEFAULT_REC_TYPE_CODE
,      DEFAULT_REC_RATE_CODE
,      OFFSET_TAX
,      OFFSET_STATUS_CODE
,      OFFSET_TAX_RATE_CODE
,      RECOVERY_RULE_CODE
,      DEF_REC_SETTLEMENT_OPTION_CODE
,      VAT_TRANSACTION_TYPE_CODE
,      ADJ_FOR_ADHOC_AMT_CODE
,      ALLOW_ADHOC_TAX_RATE_FLAG
,      TAX_CLASS
,      SOURCE_ID
,      TAXABLE_BASIS_FORMULA_CODE
,      INCLUSIVE_TAX_FLAG
,      TAX_INCLUSIVE_OVERRIDE_FLAG
,      ALLOW_EXEMPTIONS_FLAG
,      ALLOW_EXCEPTIONS_FLAG
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      RECORD_TYPE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TAX_RATE_NAME
,      SDCO_ID
,      SDEFF_FROM
,      SDEFF_TO
FROM APPS.ZX_SCO_RATES_V;

Dependencies

[top of page]

APPS

ZX_RATES_B

ZX_RATES_TL

ZX_SUBSCRIPTION_DETAILS

APPS

ZX_SCO_RATES