VIEW: APPS.ZX_WEBEXP_CLASSIFICATIONS_V

Source

View Text - Preformatted

SELECT tcc.org_id           ORG_ID,
       lkp.meaning          MEANING,
       lkp.description      DESCRIPTION,
       lkp.lookup_code      LOOKUP_CODE,
       lkp.lookup_type      LOOKUP_TYPE,
       lkp.leaf_node        LEAF_NODE,
       lkp.enabled_flag     ENABLED_FLAG,
       nvl(tcc.effective_from, lkp.start_date_active)
                            START_DATE_ACTIVE,
       CASE WHEN
             (NVL(tcc.EFFECTIVE_TO,to_date('31/12/4712','DD/MM/YYYY'))
             -nvl(lkp.end_date_active,to_date('31/12/4712','DD/MM/YYYY'))) < 0
            THEN tcc.effective_to
            ELSE  lkp.end_date_active
                            END END_DATE_ACTIVE,
       tcc.tax_type         TAX_TYPE,
       tcc.tax_class       TAX_CLASS
 FROM
       fnd_lookup_values lkp,
       zx_id_tcc_mapping_all tcc
 WHERE tcc.tax_classification_code = lkp.lookup_code
 and lkp.lookup_type = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS'
 and lkp.view_application_id = 0
 and lkp.security_group_id = 0
 and lkp.language = userenv('LANG')
 AND tcc.active_flag = 'Y'
 AND (tcc.tax_class = 'INPUT' or tcc.tax_class is NULL)
   

View Text - HTML Formatted

SELECT TCC.ORG_ID ORG_ID
, LKP.MEANING MEANING
, LKP.DESCRIPTION DESCRIPTION
, LKP.LOOKUP_CODE LOOKUP_CODE
, LKP.LOOKUP_TYPE LOOKUP_TYPE
, LKP.LEAF_NODE LEAF_NODE
, LKP.ENABLED_FLAG ENABLED_FLAG
, NVL(TCC.EFFECTIVE_FROM
, LKP.START_DATE_ACTIVE) START_DATE_ACTIVE
, CASE WHEN (NVL(TCC.EFFECTIVE_TO
, TO_DATE('31/12/4712'
, 'DD/MM/YYYY')) -NVL(LKP.END_DATE_ACTIVE
, TO_DATE('31/12/4712'
, 'DD/MM/YYYY'))) < 0 THEN TCC.EFFECTIVE_TO ELSE LKP.END_DATE_ACTIVE END END_DATE_ACTIVE
, TCC.TAX_TYPE TAX_TYPE
, TCC.TAX_CLASS TAX_CLASS FROM FND_LOOKUP_VALUES LKP
, ZX_ID_TCC_MAPPING_ALL TCC
WHERE TCC.TAX_CLASSIFICATION_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS'
AND LKP.VIEW_APPLICATION_ID = 0
AND LKP.SECURITY_GROUP_ID = 0
AND LKP.LANGUAGE = USERENV('LANG')
AND TCC.ACTIVE_FLAG = 'Y'
AND (TCC.TAX_CLASS = 'INPUT' OR TCC.TAX_CLASS IS NULL)