eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.ZX_SIM_RULE_RESULTS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length
PROCESS_ORDER	NUMBER
RESULT_ID	NUMBER
CONDITION_GROUP_CODE	VARCHAR2	(50)
CONDITION_GROUP_NAME	VARCHAR2	(80)
GROUP_PRIORITY	NUMBER
TAX_STATUS_CODE	VARCHAR2	(30)
RESULT	VARCHAR2	(150)
TAX_REGIME_CODE	VARCHAR2	(30)
TAX_REGIME_NAME	VARCHAR2	(80)
TAX	VARCHAR2	(30)
TAX_FULL_NAME	VARCHAR2	(80)
TAX_RULE_CODE	VARCHAR2	(30)
TAX_RULE_NAME	VARCHAR2	(80)
PROCESS_CODE	VARCHAR2	(30)
PROCESS_NAME	VARCHAR2	(80)
RULE_PRIORITY	NUMBER
RECOVERY_TYPE_CODE	VARCHAR2	(30)
DF_TEMPLATE_CODE	VARCHAR2	(30)
DF_TEMPLATE_NAME	VARCHAR2	(240)
STATUS_RESULT	VARCHAR2	(150)
RATE_RESULT	VARCHAR2	(150)

Query Text

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


SELECT PROCESS_ORDER
,      RESULT_ID
,      CONDITION_GROUP_CODE
,      CONDITION_GROUP_NAME
,      GROUP_PRIORITY
,      TAX_STATUS_CODE
,      RESULT
,      TAX_REGIME_CODE
,      TAX_REGIME_NAME
,      TAX
,      TAX_FULL_NAME
,      TAX_RULE_CODE
,      TAX_RULE_NAME
,      PROCESS_CODE
,      PROCESS_NAME
,      RULE_PRIORITY
,      RECOVERY_TYPE_CODE
,      DF_TEMPLATE_CODE
,      DF_TEMPLATE_NAME
,      STATUS_RESULT
,      RATE_RESULT
FROM APPS.ZX_SIM_RULE_RESULTS_V;

Dependencies

[top of page]

APPS.ZX_SIM_RULE_RESULTS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; ZX_CONDITION_GROUPS_VL; ZX_DET_FACTOR_TEMPL_VL; ZX_PROCESS_RESULTS; ZX_REGIMES_VL; ZX_RULES_VL; ZX_TAXES_VL

APPS.ZX_SIM_RULE_RESULTS_V is not referenced by any database object