VIEW: APPS.ZX_OUTPUT_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(CREATED_BY,
         -1087,
         NVL(substrb(TAG,
         1,
         50),
         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 = 'ZX_OUTPUT_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
   AND tcc.active_flag = 'Y'
   AND (tcc.tax_class = 'OUTPUT' or tcc.tax_class is NULL)
   

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(CREATED_BY
, -1087
, NVL(SUBSTRB(TAG
, 1
, 50)
, 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 = 'ZX_OUTPUT_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
AND TCC.ACTIVE_FLAG = 'Y'
AND (TCC.TAX_CLASS = 'OUTPUT' OR TCC.TAX_CLASS IS NULL)