Oracle EBS Latam Tax-China System Profiles

Oracle EBS Latam Tax-China System Profiles
Tables:-
AR_GTA_SYSTEM_PARAMETERS_ALL
AR_GTA_TAX_LIMITS_ALL

SQL Example:-

SELECT
 hou.name "OU NAME"
 ,agt.FP_tax_registration_number  "Gol Tax Registration Num"
 ,DECODE(agt.Invoice_type,0,'Special vat Invoice',2,'Common Vat invoice') "Invoice Type"
 ,agt.max_amount  "Gol Tax Max Amount"
 ,agt.max_num_of_line "Gol Tax No Line"
 ,ags.gt_currency_code  "Gol Tax Currency Code"
 ,ags.vat_tax_type_code "Gol Tax Type"
 ,ags.trx_line_split_flag "Gol Split Transaction Line"
 ,ags.auto_batch_numbering_flag "Batch Entry"
 ,ags.next_batch_number "Batch Number"
 ,ags.item_name_source_flag "Item Source flag"
 ,ags.ra_line_context_code  "Context"
 ,ags.ra_model_attribute_column "Item Model"
 ,ags.ra_tax_attribute_column   "Tax Denomination"
 FROM
 apps.AR_GTA_SYSTEM_PARAMETERS_ALL ags,
     apps.AR_GTA_TAX_LIMITS_ALL agt,
     apps.hr_operating_units hou
        WHERE 1=1
     AND agt.org_id =  ags.org_id
 AND ags.org_id = hou.organization_id;