VIEW: APPS.ZX_TAX_CLASSIFICATIONS_V

Source

View Text - Preformatted

SELECT tcc.org_id           ORG_ID,
         lkp.meaning          MEANING,
         lkp.description      DESCRIPTION,
         tcc.tax_classification_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 (select meaning,
               decode(lookup_type, 'ZX_OUTPUT_CLASSIFICATIONS',
                      DECODE(CREATED_BY,-1087,NVL(substrb(TAG,1,50),LOOKUP_CODE), LOOKUP_CODE), lookup_code) lookup_code,
               enabled_flag,
               start_date_active,
               end_date_active,
               lookup_type,
               description,
               leaf_node
          from fnd_lookup_values
         where LANGUAGE = userenv('LANG')
           and lookup_type IN ('ZX_OUTPUT_CLASSIFICATIONS',
                               'ZX_INPUT_CLASSIFICATIONS',
                               'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
           and security_group_id = 0
           and view_application_id = 0) lkp,
        zx_id_tcc_mapping_all tcc
  WHERE tcc.tax_classification_code = lkp.lookup_code

   

View Text - HTML Formatted

SELECT TCC.ORG_ID ORG_ID
, LKP.MEANING MEANING
, LKP.DESCRIPTION DESCRIPTION
, TCC.TAX_CLASSIFICATION_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 (SELECT MEANING
, DECODE(LOOKUP_TYPE
, 'ZX_OUTPUT_CLASSIFICATIONS'
, DECODE(CREATED_BY
, -1087
, NVL(SUBSTRB(TAG
, 1
, 50)
, LOOKUP_CODE)
, LOOKUP_CODE)
, LOOKUP_CODE) LOOKUP_CODE
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LOOKUP_TYPE
, DESCRIPTION
, LEAF_NODE
FROM FND_LOOKUP_VALUES
WHERE LANGUAGE = USERENV('LANG')
AND LOOKUP_TYPE IN ('ZX_OUTPUT_CLASSIFICATIONS'
, 'ZX_INPUT_CLASSIFICATIONS'
, 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
AND SECURITY_GROUP_ID = 0
AND VIEW_APPLICATION_ID = 0) LKP
, ZX_ID_TCC_MAPPING_ALL TCC
WHERE TCC.TAX_CLASSIFICATION_CODE = LKP.LOOKUP_CODE