Oracle EBS EBTAX-EBTAX REPTYPE REPCODES

Oracle EBS EBTAX-EBTAX REPTYPE REPCODES

Tables:-
ZX_REPORTING_TYPES_VL
ZX_REPORTING_CODES_VL

SQL Example:-

SELECT
a.reporting_type_code
,a.reporting_type_name
,DECODE(a.legal_message_flag,'A','All','Y','Legal Justification Message Type','N','Tax Reporting Type',a.legal_message_flag) "Reporting Type Purpose"
,(SELECT lkp1.Meaning
  FROM Fnd_lookups lkp1
  WHERE lkp1.Lookup_type = 'ZX_REPORTING_DATA'
  AND lkp1.Lookup_code = a.reporting_type_datatype_code
  AND SYSDATE BETWEEN NVL(lkp1.START_DATE_ACTIVE, SYSDATE) AND NVL(lkp1.END_DATE_ACTIVE, SYSDATE)
  ) "Data Type"
  ,a.has_reporting_codes_flag
  ,a.tax_regime_code
  ,a.Tax
  ,a.max_length
  ,a.min_length
  ,a.effective_FROM "REP Type EFF From"
  ,a.effective_to "REP Type EFF TO"
  ,b.reporting_code_char_value
  ,b.reporting_code_name
  ,b.effective_FROM "REP CODE EFF FROM"
  ,b.effective_to "REP CODE EFF TO"
  FROM apps.ZX_REPORTING_TYPES_VL a,
apps.ZX_REPORTING_CODES_VL b WHERE 1=1 AND a.reporting_type_id =b.reporting_type_id(+);