Oracle EBS EBTAX-EBTAX Tax Rules
Oracle EBS EBTAX-EBTAX Tax Rules
Tables:-
ZX_RULES_VL
ZX_PROCESS_RESULTS
ZX_CONDITION_GROUPS_VL
ZX_DET_FACTOR_TEMPL_VL
ZX_CONDITIONS
ZX_DETERMINING_FACTORS_VL
ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_DETAILS
ZX_REGIMES_USAGES
ZX_REGIMES_VL
ZX_TAXES_VL
SQL Example:-
SELECT
DECODE(RuleTLEO.CONTENT_OWNER_ID,-99,'Global Configuration Owner',hou.name) "Configuration Owner"
,RuleTLEO.TAX_REGIME_CODE "Tax Regime Code"
,RuleTLEO.TAX "Tax"
,lkp.meaning "Rule Type"
,RuleTLEO.DETERMINING_FACTOR_CQ_CODE "Dflt Determine Tax Rate Rule"
,RuleTLEO.TAX_RULE_CODE "Rule Code"
,RuleTLEO.TAX_RULE_NAME "Rule Name"
,RuleTLEO.PRIORITY "Rule Order"
,RuleTLEO.EFFECTIVE_FROM
,RuleTLEO.EFFECTIVE_TO
,RuleTLEO.ENABLED_FLAG "Enabled"
,b.TAX_STATUS_CODE "Tax Status Code"
,(SELECT lkp2.MEANING
FROM FND_LOOKUPS lkp2
WHERE RuleTLEO.RECOVERY_TYPE_CODE = lkp2.LOOKUP_CODE
AND lkp2.LOOKUP_TYPE = 'ZX_RECOVERY_TYPES'
AND SYSDATE BETWEEN NVL(lkp2.START_DATE_ACTIVE , SYSDATE) AND NVL(lkp2.END_DATE_ACTIVE, SYSDATE)
AND lkp2.ENABLED_FLAG = 'Y'
) "Recovery Type"
,DECODE(RuleTLEO.TAX_EVENT_CLASS_CODE, NULL, DECODE(RuleTLEO.APPLICATION_ID,NULL,NULL,'EVENT_CLASS'),'TAX_EVENT_CLASS') "Event Class Category"
,DECODE(RuleTLEO.GEOGRAPHY_ID, NULL, 'No','Yes') "Geography Specific Rule"
,RuleTLEO.DET_FACTOR_TEMPL_CODE "Determining Factor Set Code"
,d.DET_FACTOR_TEMPL_NAME "Determining Factor Set Name"
,b.CONDITION_GROUP_CODE "Condition Set Code"
,c.CONDITION_GROUP_NAME "Name"
,b.priority "Order"
,DECODE(b.RESULT_TYPE_CODE, 'ADDRESS_TYPE',
(SELECT MEANING
FROM FND_LOOKUPS
WHERE b.ALPHANUMERIC_RESULT = LOOKUP_CODE
AND LOOKUP_TYPE = 'ZX_PLACE_OF_SUPPLY_TYPE'
AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
AND NVL(ENABLED_FLAG, 'N') = 'Y'
), 'YES_NO',
(SELECT MEANING
FROM FND_LOOKUPS
WHERE b.ALPHANUMERIC_RESULT = LOOKUP_CODE
AND LOOKUP_TYPE = 'ZX_YES_NO'
AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
AND NVL(ENABLED_FLAG, 'N') = 'Y'
), 'APPLICABILITY',
(SELECT MEANING
FROM FND_LOOKUPS
WHERE b.ALPHANUMERIC_RESULT = LOOKUP_CODE
AND LOOKUP_TYPE = 'ZX_APPLICABILITY_TYPES'
AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
AND NVL(ENABLED_FLAG, 'N') = 'Y'
), b.ALPHANUMERIC_RESULT) "Result"
,b.enabled_flag "Condition Set Enable"
,(SELECT lkp4.meaning
FROM FND_LOOKUPS lkp4
WHERE lkp4.lookup_type ='ZX_DETERMINING_FACTOR_CLASS'
AND lkp4.lookup_code =e.DETERMINING_FACTOR_CLASS_CODE
AND SYSDATE BETWEEN lkp4.START_DATE_ACTIVE AND NVL(lkp4.END_DATE_ACTIVE, SYSDATE)
AND NVL(lkp4.ENABLED_FLAG, 'N') = 'Y'
) "Determining Factor Class"
,CASE
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'USER_DEFINED_GEOGRAPHY'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'GEOGRAPHY'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_PLACE_OF_SUPPLY_TYPE', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_SITE_FISCAL_CLASS'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_GEO_PARTY_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'PARTY'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_PARTY_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'LEGAL_PARTY_FISCAL_CLASS'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_LEGAL_PARTY_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'REGISTRATION'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_REGISTRATION_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'ACCOUNTING_FLEXFIELD'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_ACCOUNT_FLEX_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_GENERIC_CLASSIFICATION'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'TRX_GENERIC_CLASSIFICATION'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'DOCUMENT'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'TRX_FISCAL_CLASS'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_PROD_TRX_CATEG', e.DETERMINING_FACTOR_CQ_CODE)
ELSE NULL
END "Class Qualifier"
,f.DETERMINING_FACTOR_NAME "Determining Factor Name"
,e.OPERATOR_CODE "Operator"
,e.VALUE_LOW "From Range"
,e.VALUE_HIGH "To Range"
,e.IGNORE_FLAG "Ignore Condition"
,CASE WHEN RuleTLEO.service_type_code='DET_APPLICABLE_TAXES'
THEN DECODE(TaxTLEO.APPLICABLE_BY_DEFAULT_FLAG, 'Y', 'Applicable','Not Applicable')
WHEN RuleTLEO.service_type_code='CALCULATE_TAX_AMOUNTS'
THEN TaxTLEO.DEF_TAX_CALC_FORMULA
WHEN RuleTLEO.service_type_code='DET_PLACE_OF_SUPPLY'
THEN
(SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'ZX_PLACE_OF_SUPPLY_TYPE' AND LOOKUP_CODE =TaxTLEO.DEF_PLACE_OF_SUPPLY_TYPE_CODE)
WHEN RuleTLEO.service_type_code='DET_TAX_RATE'
THEN
(SELECT distinct TAX_RATE_CODE FROM ZX_MCO_LV_RATES_V R
WHERE R.TAX_REGIME_CODE =RuleTLEO.TAX_REGIME_CODE AND R.TAX = RuleTLEO.TAX AND R.CONTENT_OWNER_ID =RuleTLEO.CONTENT_OWNER_ID AND Nvl(R.active_flag,'N') = 'Y'
AND NVL(R.DEFAULT_RATE_FLAG,'N') = 'Y'
AND R.TAX_STATUS_CODE =(SELECT distinct st.TAX_STATUS_CODE FROM ZX_MCO_LV_STATUS_V st where st.TAX_REGIME_CODE =RuleTLEO.TAX_REGIME_CODE AND st.TAX = RuleTLEO.TAX and st.DEFAULT_STATUS_FLAG = 'Y' and st.CONTENT_OWNER_ID=RuleTLEO.CONTENT_OWNER_ID)
)
WHEN RuleTLEO.service_type_code='DET_TAX_REGISTRATION'
THEN
(SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'ZX_REGISTRATION_CQ' AND LOOKUP_CODE =TaxTLEO.DEF_REGISTR_PARTY_TYPE_CODE)
WHEN RuleTLEO.service_type_code='DET_TAX_STATUS'
THEN
(SELECT distinct st.TAX_STATUS_CODE FROM ZX_MCO_LV_STATUS_V st where st.TAX_REGIME_CODE =RuleTLEO.TAX_REGIME_CODE AND st.TAX = RuleTLEO.TAX and st.DEFAULT_STATUS_FLAG = 'Y' and st.CONTENT_OWNER_ID=RuleTLEO.CONTENT_OWNER_ID)
WHEN RuleTLEO.service_type_code='DET_TAXABLE_BASIS'
THEN TaxTLEO.DEF_TAXABLE_BASIS_FORMULA
END default_val
FROM APPS.ZX_RULES_VL RuleTLEO,
APPS.ZX_PROCESS_RESULTS b,
APPS.ZX_CONDITION_GROUPS_VL c,
APPS.ZX_DET_FACTOR_TEMPL_VL d,
APPS.ZX_CONDITIONS e,
APPS.ZX_DETERMINING_FACTORS_VL f,
APPS.ZX_PARTY_TAX_PROFILE PTP,
APPS.ZX_SUBSCRIPTION_DETAILS ZSD,
APPS.HR_OPERATING_UNITS HOU,
APPS.ZX_REGIMES_USAGES ZRU,
APPS.ZX_REGIMES_VL RegimeTLEO,
APPS.ZX_TAXES_VL TaxTLEO,
APPS.FND_LOOKUPS lkp WHERE 1=1 AND RuleTLEO.TAX_RULE_ID = b.TAX_RULE_ID
AND b.CONDITION_GROUP_ID = c.CONDITION_GROUP_ID
AND c.CONDITION_GROUP_CODE = e.CONDITION_GROUP_CODE
AND RuleTLEO.DET_FACTOR_TEMPL_CODE = d.DET_FACTOR_TEMPL_CODE
AND e.DETERMINING_FACTOR_CLASS_CODE = f.DETERMINING_FACTOR_CLASS_CODE
AND e.DETERMINING_FACTOR_CODE = f.DETERMINING_FACTOR_CODE
AND RuleTLEO. TAX_REGIME_CODE = RegimeTLEO. TAX_REGIME_CODE
AND RuleTLEO. TAX = TaxTLEO.TAX
AND RuleTLEO.TAX_REGIME_CODE = TaxTLEO.TAX_REGIME_CODE
AND zru.tax_regime_id = RegimeTLEO.tax_regime_id
AND RegimeTLEO.tax_regime_code = TaxTLEO.tax_regime_code
AND ptp.party_type_code = 'OU'
AND ptp.party_id = hou.organization_id
AND zru.first_pty_org_id = ptp.party_tax_profile_id
AND (RuleTLEO.CONTENT_OWNER_id=ptp.party_tax_profile_id OR RuleTLEO.CONTENT_OWNER_id=-99)
AND zru.first_pty_org_id = zsd.first_pty_org_id
AND zsd.tax_regime_code = ZRU.TAX_REGIME_CODE
AND zsd.parent_first_pty_org_id = -99
AND SYSDATE BETWEEN zsd.effective_FROM AND NVL(zsd.effective_to,SYSDATE)
AND RuleTLEO.service_type_code=lkp.LOOKUP_CODE
AND lkp.LOOKUP_TYPE = 'ZX_SERVICE_TYPE_CODES'
AND lkp.LOOKUP_CODE NOT IN ('DET_TAX_REGIMES', 'TAX_LINES_DETERMINATION','DET_APPLICABLE_REGIMES','DET_OFFSET_TAX','DET_TAX_LINES','ROUNDING','DET_APPLICABLE_RECOVERY_TYPES', 'EXCEPTION', 'EXEMPTIONS')
AND SYSDATE BETWEEN lkp.START_DATE_ACTIVE AND NVL(lkp.END_DATE_ACTIVE, SYSDATE)
AND NVL(lkp.ENABLED_FLAG, 'N') = 'Y'
AND hou.name= '&&';
Tables:-
ZX_RULES_VL
ZX_PROCESS_RESULTS
ZX_CONDITION_GROUPS_VL
ZX_DET_FACTOR_TEMPL_VL
ZX_CONDITIONS
ZX_DETERMINING_FACTORS_VL
ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_DETAILS
ZX_REGIMES_USAGES
ZX_REGIMES_VL
ZX_TAXES_VL
SQL Example:-
SELECT
DECODE(RuleTLEO.CONTENT_OWNER_ID,-99,'Global Configuration Owner',hou.name) "Configuration Owner"
,RuleTLEO.TAX_REGIME_CODE "Tax Regime Code"
,RuleTLEO.TAX "Tax"
,lkp.meaning "Rule Type"
,RuleTLEO.DETERMINING_FACTOR_CQ_CODE "Dflt Determine Tax Rate Rule"
,RuleTLEO.TAX_RULE_CODE "Rule Code"
,RuleTLEO.TAX_RULE_NAME "Rule Name"
,RuleTLEO.PRIORITY "Rule Order"
,RuleTLEO.EFFECTIVE_FROM
,RuleTLEO.EFFECTIVE_TO
,RuleTLEO.ENABLED_FLAG "Enabled"
,b.TAX_STATUS_CODE "Tax Status Code"
,(SELECT lkp2.MEANING
FROM FND_LOOKUPS lkp2
WHERE RuleTLEO.RECOVERY_TYPE_CODE = lkp2.LOOKUP_CODE
AND lkp2.LOOKUP_TYPE = 'ZX_RECOVERY_TYPES'
AND SYSDATE BETWEEN NVL(lkp2.START_DATE_ACTIVE , SYSDATE) AND NVL(lkp2.END_DATE_ACTIVE, SYSDATE)
AND lkp2.ENABLED_FLAG = 'Y'
) "Recovery Type"
,DECODE(RuleTLEO.TAX_EVENT_CLASS_CODE, NULL, DECODE(RuleTLEO.APPLICATION_ID,NULL,NULL,'EVENT_CLASS'),'TAX_EVENT_CLASS') "Event Class Category"
,DECODE(RuleTLEO.GEOGRAPHY_ID, NULL, 'No','Yes') "Geography Specific Rule"
,RuleTLEO.DET_FACTOR_TEMPL_CODE "Determining Factor Set Code"
,d.DET_FACTOR_TEMPL_NAME "Determining Factor Set Name"
,b.CONDITION_GROUP_CODE "Condition Set Code"
,c.CONDITION_GROUP_NAME "Name"
,b.priority "Order"
,DECODE(b.RESULT_TYPE_CODE, 'ADDRESS_TYPE',
(SELECT MEANING
FROM FND_LOOKUPS
WHERE b.ALPHANUMERIC_RESULT = LOOKUP_CODE
AND LOOKUP_TYPE = 'ZX_PLACE_OF_SUPPLY_TYPE'
AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
AND NVL(ENABLED_FLAG, 'N') = 'Y'
), 'YES_NO',
(SELECT MEANING
FROM FND_LOOKUPS
WHERE b.ALPHANUMERIC_RESULT = LOOKUP_CODE
AND LOOKUP_TYPE = 'ZX_YES_NO'
AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
AND NVL(ENABLED_FLAG, 'N') = 'Y'
), 'APPLICABILITY',
(SELECT MEANING
FROM FND_LOOKUPS
WHERE b.ALPHANUMERIC_RESULT = LOOKUP_CODE
AND LOOKUP_TYPE = 'ZX_APPLICABILITY_TYPES'
AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE)
AND NVL(ENABLED_FLAG, 'N') = 'Y'
), b.ALPHANUMERIC_RESULT) "Result"
,b.enabled_flag "Condition Set Enable"
,(SELECT lkp4.meaning
FROM FND_LOOKUPS lkp4
WHERE lkp4.lookup_type ='ZX_DETERMINING_FACTOR_CLASS'
AND lkp4.lookup_code =e.DETERMINING_FACTOR_CLASS_CODE
AND SYSDATE BETWEEN lkp4.START_DATE_ACTIVE AND NVL(lkp4.END_DATE_ACTIVE, SYSDATE)
AND NVL(lkp4.ENABLED_FLAG, 'N') = 'Y'
) "Determining Factor Class"
,CASE
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'USER_DEFINED_GEOGRAPHY'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'GEOGRAPHY'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_PLACE_OF_SUPPLY_TYPE', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_SITE_FISCAL_CLASS'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_GEO_PARTY_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'PARTY'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_PARTY_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'LEGAL_PARTY_FISCAL_CLASS'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_LEGAL_PARTY_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'REGISTRATION'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_REGISTRATION_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'ACCOUNTING_FLEXFIELD'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_ACCOUNT_FLEX_CQ', e.DETERMINING_FACTOR_CQ_CODE)
WHEN e.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_GENERIC_CLASSIFICATION'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'TRX_GENERIC_CLASSIFICATION'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'DOCUMENT'
OR e.DETERMINING_FACTOR_CLASS_CODE = 'TRX_FISCAL_CLASS'
THEN ZX_UTIL_PKG.get_lookup_meaning('ZX_PROD_TRX_CATEG', e.DETERMINING_FACTOR_CQ_CODE)
ELSE NULL
END "Class Qualifier"
,f.DETERMINING_FACTOR_NAME "Determining Factor Name"
,e.OPERATOR_CODE "Operator"
,e.VALUE_LOW "From Range"
,e.VALUE_HIGH "To Range"
,e.IGNORE_FLAG "Ignore Condition"
,CASE WHEN RuleTLEO.service_type_code='DET_APPLICABLE_TAXES'
THEN DECODE(TaxTLEO.APPLICABLE_BY_DEFAULT_FLAG, 'Y', 'Applicable','Not Applicable')
WHEN RuleTLEO.service_type_code='CALCULATE_TAX_AMOUNTS'
THEN TaxTLEO.DEF_TAX_CALC_FORMULA
WHEN RuleTLEO.service_type_code='DET_PLACE_OF_SUPPLY'
THEN
(SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'ZX_PLACE_OF_SUPPLY_TYPE' AND LOOKUP_CODE =TaxTLEO.DEF_PLACE_OF_SUPPLY_TYPE_CODE)
WHEN RuleTLEO.service_type_code='DET_TAX_RATE'
THEN
(SELECT distinct TAX_RATE_CODE FROM ZX_MCO_LV_RATES_V R
WHERE R.TAX_REGIME_CODE =RuleTLEO.TAX_REGIME_CODE AND R.TAX = RuleTLEO.TAX AND R.CONTENT_OWNER_ID =RuleTLEO.CONTENT_OWNER_ID AND Nvl(R.active_flag,'N') = 'Y'
AND NVL(R.DEFAULT_RATE_FLAG,'N') = 'Y'
AND R.TAX_STATUS_CODE =(SELECT distinct st.TAX_STATUS_CODE FROM ZX_MCO_LV_STATUS_V st where st.TAX_REGIME_CODE =RuleTLEO.TAX_REGIME_CODE AND st.TAX = RuleTLEO.TAX and st.DEFAULT_STATUS_FLAG = 'Y' and st.CONTENT_OWNER_ID=RuleTLEO.CONTENT_OWNER_ID)
)
WHEN RuleTLEO.service_type_code='DET_TAX_REGISTRATION'
THEN
(SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'ZX_REGISTRATION_CQ' AND LOOKUP_CODE =TaxTLEO.DEF_REGISTR_PARTY_TYPE_CODE)
WHEN RuleTLEO.service_type_code='DET_TAX_STATUS'
THEN
(SELECT distinct st.TAX_STATUS_CODE FROM ZX_MCO_LV_STATUS_V st where st.TAX_REGIME_CODE =RuleTLEO.TAX_REGIME_CODE AND st.TAX = RuleTLEO.TAX and st.DEFAULT_STATUS_FLAG = 'Y' and st.CONTENT_OWNER_ID=RuleTLEO.CONTENT_OWNER_ID)
WHEN RuleTLEO.service_type_code='DET_TAXABLE_BASIS'
THEN TaxTLEO.DEF_TAXABLE_BASIS_FORMULA
END default_val
FROM APPS.ZX_RULES_VL RuleTLEO,
APPS.ZX_PROCESS_RESULTS b,
APPS.ZX_CONDITION_GROUPS_VL c,
APPS.ZX_DET_FACTOR_TEMPL_VL d,
APPS.ZX_CONDITIONS e,
APPS.ZX_DETERMINING_FACTORS_VL f,
APPS.ZX_PARTY_TAX_PROFILE PTP,
APPS.ZX_SUBSCRIPTION_DETAILS ZSD,
APPS.HR_OPERATING_UNITS HOU,
APPS.ZX_REGIMES_USAGES ZRU,
APPS.ZX_REGIMES_VL RegimeTLEO,
APPS.ZX_TAXES_VL TaxTLEO,
APPS.FND_LOOKUPS lkp WHERE 1=1 AND RuleTLEO.TAX_RULE_ID = b.TAX_RULE_ID
AND b.CONDITION_GROUP_ID = c.CONDITION_GROUP_ID
AND c.CONDITION_GROUP_CODE = e.CONDITION_GROUP_CODE
AND RuleTLEO.DET_FACTOR_TEMPL_CODE = d.DET_FACTOR_TEMPL_CODE
AND e.DETERMINING_FACTOR_CLASS_CODE = f.DETERMINING_FACTOR_CLASS_CODE
AND e.DETERMINING_FACTOR_CODE = f.DETERMINING_FACTOR_CODE
AND RuleTLEO. TAX_REGIME_CODE = RegimeTLEO. TAX_REGIME_CODE
AND RuleTLEO. TAX = TaxTLEO.TAX
AND RuleTLEO.TAX_REGIME_CODE = TaxTLEO.TAX_REGIME_CODE
AND zru.tax_regime_id = RegimeTLEO.tax_regime_id
AND RegimeTLEO.tax_regime_code = TaxTLEO.tax_regime_code
AND ptp.party_type_code = 'OU'
AND ptp.party_id = hou.organization_id
AND zru.first_pty_org_id = ptp.party_tax_profile_id
AND (RuleTLEO.CONTENT_OWNER_id=ptp.party_tax_profile_id OR RuleTLEO.CONTENT_OWNER_id=-99)
AND zru.first_pty_org_id = zsd.first_pty_org_id
AND zsd.tax_regime_code = ZRU.TAX_REGIME_CODE
AND zsd.parent_first_pty_org_id = -99
AND SYSDATE BETWEEN zsd.effective_FROM AND NVL(zsd.effective_to,SYSDATE)
AND RuleTLEO.service_type_code=lkp.LOOKUP_CODE
AND lkp.LOOKUP_TYPE = 'ZX_SERVICE_TYPE_CODES'
AND lkp.LOOKUP_CODE NOT IN ('DET_TAX_REGIMES', 'TAX_LINES_DETERMINATION','DET_APPLICABLE_REGIMES','DET_OFFSET_TAX','DET_TAX_LINES','ROUNDING','DET_APPLICABLE_RECOVERY_TYPES', 'EXCEPTION', 'EXEMPTIONS')
AND SYSDATE BETWEEN lkp.START_DATE_ACTIVE AND NVL(lkp.END_DATE_ACTIVE, SYSDATE)
AND NVL(lkp.ENABLED_FLAG, 'N') = 'Y'
AND hou.name= '&&';
posted by Ashish Kishore @ 8:46 PM
0 Comments:
Post a Comment
<< Home