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.

VIEW: APPS.ZX_SIM_RULE_RESULTS_V

Source

View Text - Preformatted


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,
    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 --( TAX.PLACE_OF_SUPPLY_RULE_FLAG = 'N' OR
       --  TAX.PLACE_OF_SUPPLY_RULE_FLAG IS NULL ) AND
       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.APPLICABILITY_RULE_FLAG = 'N' OR
         --  TAX.APPLICABILITY_RULE_FLAG IS NULL ) AND
         (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 --( TAX.REGISTRATION_TYPE_RULE_FLAG = 'N' OR
         --  TAX.REGISTRATION_TYPE_RULE_FLAG IS NULL ) AND
         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.TAX_STATUS_RULE_FLAG = 'N' OR
         --  TAX.TAX_STATUS_RULE_FLAG IS NULL ) AND
         ( 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.TAX_RATE_RULE_FLAG = 'N' OR
         --  TAX.TAX_RATE_RULE_FLAG IS NULL ) AND
         ( 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 --(TAX.TAXABLE_BASIS_RULE_FLAG = 'N' OR
         -- TAX.TAXABLE_BASIS_RULE_FLAG IS NULL) AND
         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 --(TAX.TAX_CALC_RULE_FLAG = 'N' OR
         -- TAX.TAX_CALC_RULE_FLAG IS NULL) AND
         REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE

View Text - HTML Formatted

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
, 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 --( TAX.PLACE_OF_SUPPLY_RULE_FLAG = 'N' OR -- TAX.PLACE_OF_SUPPLY_RULE_FLAG IS NULL ) AND 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.APPLICABILITY_RULE_FLAG = 'N' OR -- TAX.APPLICABILITY_RULE_FLAG IS NULL ) AND (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 --( TAX.REGISTRATION_TYPE_RULE_FLAG = 'N' OR -- TAX.REGISTRATION_TYPE_RULE_FLAG IS NULL ) AND 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.TAX_STATUS_RULE_FLAG = 'N' OR -- TAX.TAX_STATUS_RULE_FLAG IS NULL ) AND ( 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.TAX_RATE_RULE_FLAG = 'N' OR -- TAX.TAX_RATE_RULE_FLAG IS NULL ) AND ( 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 --(TAX.TAXABLE_BASIS_RULE_FLAG = 'N' OR -- TAX.TAXABLE_BASIS_RULE_FLAG IS NULL) AND 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 --(TAX.TAX_CALC_RULE_FLAG = 'N' OR -- TAX.TAX_CALC_RULE_FLAG IS NULL) AND REGIME.TAX_REGIME_CODE = TAX.TAX_REGIME_CODE