AP AR tax Code Extract Query

--AP Tax Codes

SELECT atc.*,
    gcc.segment1
    ||'-'
    ||gcc.segment2
    ||'-'
    ||gcc.segment3
    ||'-'
    ||gcc.segment4
    ||'-'
    ||gcc.segment5
    ||'-'
    ||gcc.segment6
    ||'-'
    ||gcc.segment7
    ||'-'
    ||gcc.segment8
    ||'-'
    ||gcc.segment9
    ||'-'
    ||gcc.segment10 tax_code_combination  
FROM apps.ap_tax_codes_all atc,
apps.gl_code_combinations gcc
WHERE
gcc.code_combination_id = atc.tax_code_combination_id
AND atc.enabled_flag = 'Y'
AND SYSDATE BETWEEN nvl(atc.start_date, SYSDATE) AND nvl(atc.inactive_date,SYSDATE)
AND atc.org_id     = 2659;

-- AR tax Code:

SELECT avtb.* ,
  gcc.segment1
  ||'-'
  ||gcc.segment2
  ||'-'
  ||gcc.segment3
  ||'-'
  ||gcc.segment4
  ||'-'
  ||gcc.segment5
  ||'-'
  ||gcc.segment6
  ||'-'
  ||gcc.segment7
  ||'-'
  ||gcc.segment8
  ||'-'
  ||gcc.segment9
  ||'-'
  ||gcc.segment10 tax_code_combination
FROM apps.ar_vat_tax_all_b avtb,
  apps.ar_vat_tax_all_tl avtt,
  apps.gl_code_combinations gcc
WHERE gcc.code_combination_id (+) = avtb.tax_account_id
AND avtb.vat_tax_id               = avtt.vat_tax_id
AND avtt.language                 = 'US'
AND avtb.enabled_flag             = 'Y'
AND SYSDATE BETWEEN nvl(avtb.start_date, SYSDATE) AND nvl(avtb.end_date,SYSDATE)
AND avtt.org_id = :p_org_id