Oracle EBS EBTAX-EBTax Determining Factors

Oracle EBS EBTAX-EBTax Determining Factors

Tables:-
ZX_DETERMINING_FACTORS_VL

SQL Example:-

SELECT
Lookup.MEANING  "Determining Factor Class"
,zdfv.DETERMINING_FACTOR_NAME "Determining Factor Name"
,zdfv.DETERMINING_FACTOR_DESC "Description"
,CASE
    WHEN zdfv.tax_rules_flag = 'Y'
    THEN 'Tax Rules'
    WHEN zdfv.tax_regime_det_flag = 'Y'
    THEN 'Tax Regime Determination'
    WHEN zdfv.taxable_basis_flag = 'Y'
    THEN 'Taxable Basis Formula'
  END "Determining Factor Usage"
  FROM APPS.ZX_DETERMINING_FACTORS_VL zdfv,
  APPS.FND_LOOKUPS Lookup
  WHERE 1=1
  AND zdfv.DETERMINING_FACTOR_CLASS_CODE = Lookup.LOOKUP_CODE
AND Lookup.LOOKUP_TYPE                 = 'ZX_DETERMINING_FACTOR_CLASS'
AND Lookup.LOOKUP_CODE                <> 'DERIVED'
AND SYSDATE BETWEEN Lookup.START_DATE_ACTIVE AND NVL(Lookup.END_DATE_ACTIVE, SYSDATE)
AND NVL(Lookup.ENABLED_FLAG, 'N') = 'Y'
AND( zdfv.tax_rules_flag          = 'Y'
OR zdfv.tax_regime_det_flag       = 'Y'
OR zdfv.taxable_basis_flag        = 'Y');