Oracle EBS EBTAX-Document Classifications

Oracle EBS EBTAX-Document Classifications

Tables:-
ZX_FC_TYPES_VL
ZX_FC_CODES_DENORM_B

SQL Example:-

SELECT
a.CLASSIFICATION_TYPE_CODE FC_TYpe_Code
,a.CLASSIFICATION_TYPE_NAME FC_Type_Name
 ,a.CLASSIFICATION_TYPE_LEVEL_CODE Levels
 ,a.DELIMITER
 ,a.EFFECTIVE_FROM Type_EFF_FROM
 ,a.EFFECTIVE_TO Type_EFF_TO
 ,b.CLASSIFICATION_CODE FC_Code
 ,b.CLASSIFICATION_NAME FC_Name
 ,c.geography_name
 ,b.EFFECTIVE_FROM Code_EFF_FROM
 ,b.EFFECTIVE_TO Code_EFF_To
 FROM APPS.ZX_FC_TYPES_VL a ,
 APPS.ZX_FC_CODES_DENORM_B b,
 APPS.HZ_GEOGRAPHIES c,
 APPS.XLE_ENTITY_PROFILES d,
 APPS.HR_OPERATING_UNITS e
 WHERE 1=1 AND a.classification_type_code=a.classification_type_code
  and b.language='US'
  AND b.country_code = c.geography_code
 AND  c.geography_type   = 'COUNTRY'
 and c.geography_id =d.geography_id
 AND d.legal_entity_id=e.DEFAULT_LEGAL_CONTEXT_ID
 AND a.classification_type_code = 'DOCUMENT_SUBTYPE';