Oracle EBS Latam Tax-China Golden Tax Rules

Oracle EBS Latam Tax-China Golden Tax Rules
Tables:-
AR_GTA_RULE_HEADERS_ALL
AR_GTA_RULE_TRX_TYPES_ALL

SQL Example:-

SELECT
hou.name
,TO_CHAR(agr.start_date,'DD-MM-YYYY')
 ,agr.rule_name
 ,agr.description
 ,DECODE(agr.Invoice_type,0,'Special vat Invoice',2,'Common Vat invoice')
 ,agr.primary_flag
 ,(select name from APPS.RA_CUST_TRX_TYPES_ALL RCTT where cust_trx_type_id = agrt.cust_trx_type_id)
 ,DECODE(agrt.condition_rule,'I','Include','E','Exclude')
 ,agrt.description
 ,agr.sales_list_flag
 ,agr.currency_option
 ,agr.specific_currency_code
 FROM
 apps.AR_GTA_RULE_HEADERS_ALL agr,
 apps.AR_GTA_RULE_TRX_TYPES_ALL agrt,
 apps.hr_operating_units hou
 WHERE 1=1
 AND agr.rule_header_id = agrt.rule_header_id
AND   agr.org_id =  agrt.org_id
AND   agr.org_id =  hou.organization_id ;