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.LANGUAGE = userenv('LANG')
AND lkp.lookup_type IN ('ZX_INPUT_CLASSIFICATIONS',
'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
AND lkp.view_application_id = 0
AND lkp.security_group_id = 0
AND tcc.active_flag = 'Y'
AND (tcc.tax_class = 'INPUT' or tcc.tax_class is NULL)
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.LANGUAGE = USERENV('LANG')
AND LKP.LOOKUP_TYPE IN ('ZX_INPUT_CLASSIFICATIONS'
,
'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
AND LKP.VIEW_APPLICATION_ID = 0
AND LKP.SECURITY_GROUP_ID = 0
AND TCC.ACTIVE_FLAG = 'Y'
AND (TCC.TAX_CLASS = 'INPUT' OR TCC.TAX_CLASS IS NULL)
|
|
|