[Home] [Help]
View: ZX_SIM_RULE_RESULTS_V
View Text
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