ZX_SIM_RULE_RESULTS_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
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

Query

SQL_Statement

SELECT decode ( RU.SERVICE_TYPE_CODE, 'DET_DIRECT_RATE', 1, 'DET_PLACE_OF_SUPPLY', 2, 'DET_APPLICABLE_TAXES', 3, 'DET_TAX_REGISTRATION', 4, 'DET_TAX_STATUS', 5, 'DET_TAX_RATE', 6, 'DET_TAXABLE_BASIS', 7, 'CALCULATE_TAX_AMOUNTS', 8, 10 ) , RESULT_ID, DS.CONDITION_GROUP_CODE , DS.CONDITION_GROUP_NAME, PR.PRIORITY GROUP_PRIORITY, PR.TAX_STATUS_CODE, NVL ( PR.ALPHANUMERIC_RESULT, NVL ( PR.NUMERIC_RESULT, PR.RESULT_API ) ) RESULT, RU.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, RU.TAX, TAX.TAX_FULL_NAME, RU.TAX_RULE_CODE, TAX_RULE_NAME, RU.SERVICE_TYPE_CODE PROCESS_CODE, PROCESS.MEANING PROCESS_NAME, RU.PRIORITY RULE_PRIORITY, RU.RECOVERY_TYPE_CODE, RU.DET_FACTOR_TEMPL_CODE DF_TEMPLATE_CODE, DFT.DET_FACTOR_TEMPL_NAME DF_TEMPLATE_NAME, PR.STATUS_RESULT, PR.RATE_RESULT FROM ZX_PROCESS_RESULTS PR, ZX_RULES_VL RU, ZX_DET_FACTOR_TEMPL_VL DFT, ZX_CONDITION_GROUPS_VL DS, FND_LOOKUPS PROCESS, ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE PR.TAX_RULE_ID = RU.TAX_RULE_ID AND RU.DET_FACTOR_TEMPL_CODE = DFT.DET_FACTOR_TEMPL_CODE AND PR.CONDITION_GROUP_ID = DS.CONDITION_GROUP_ID AND RU.SERVICE_TYPE_CODE = PROCESS.LOOKUP_CODE AND PROCESS.LOOKUP_TYPE = 'ZX_SERVICE_TYPE_CODES' AND (RU.TAX = TAX.TAX AND RU.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE) AND RU.TAX_REGIME_CODE = REGIME.TAX_REGIME_CODE AND ( TAX.APPLICABILITY_RULE_FLAG = 'Y' OR TAX.TAX_STATUS_RULE_FLAG = 'Y' OR TAX.TAX_RATE_RULE_FLAG = 'Y' OR TAX.PLACE_OF_SUPPLY_RULE_FLAG = 'Y' OR TAX.DIRECT_RATE_RULE_FLAG = 'Y' OR TAX.TAXABLE_BASIS_RULE_FLAG = 'Y' OR TAX.TAX_CALC_RULE_FLAG = 'Y' OR TAX.REGISTRATION_TYPE_RULE_FLAG = 'Y') UNION ALL SELECT 2, -9998, NULL, NULL, NULL, NULL, 'Default', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'DET_PLACE_OF_SUPPLY', 'Determine Place of Supply', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE UNION ALL SELECT 3, -9991, NULL, NULL, NULL, NULL, 'Applicable', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'DET_APPLICABLE_TAXES', 'Determine Applicable Taxes', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE (TAX.DIRECT_RATE_RULE_FLAG = 'N' OR TAX.DIRECT_RATE_RULE_FLAG IS NULL) AND REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE UNION ALL SELECT 4, -9997, NULL, NULL, NULL, NULL, 'Default', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'DET_TAX_REGISTRATION', 'Determine Tax Registration', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE UNION ALL SELECT 5, -9992, NULL, NULL, NULL, NULL, 'Default', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'DET_TAX_STATUS', 'Determine Tax Status', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE ( TAX.DIRECT_RATE_RULE_FLAG = 'N' OR TAX.DIRECT_RATE_RULE_FLAG IS NULL ) AND REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE UNION ALL SELECT 6, -9993, NULL, NULL, NULL, NULL, 'Default', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'DET_TAX_RATE', 'Determine Tax Rate', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE ( TAX.DIRECT_RATE_RULE_FLAG = 'N' OR TAX.DIRECT_RATE_RULE_FLAG IS NULL ) AND REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE UNION ALL SELECT 7, -9994, NULL, NULL, NULL, NULL, 'Line Amount', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'DET_TAXABLE_BASIS', 'Determine Taxable Basis', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE UNION ALL SELECT 8, -9996, NULL, NULL, NULL, NULL, 'Standard', REGIME.TAX_REGIME_CODE, REGIME.TAX_REGIME_NAME, TAX.TAX, TAX.TAX_FULL_NAME, NULL, NULL, 'CALCULATE_TAX_AMOUNTS', 'Calculate Tax Amounts', NULL, NULL, NULL, NULL, NULL, NULL FROM ZX_REGIMES_VL REGIME, ZX_TAXES_VL TAX WHERE REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE