SELECT f.ad_client_id,
    f.ad_org_id,
    f.isactive,
    f.created,
    f.createdby,
    f.updated,
    f.updatedby,
    f.fact_acct_id,
    f.c_acctschema_id,
    f.account_id,
    f.datetrx,
    f.dateacct,
    f.c_period_id,
    f.ad_table_id,
    f.record_id,
    f.line_id,
    f.gl_category_id,
    f.gl_budget_id,
    f.c_tax_id,
    f.m_locator_id,
    f.postingtype,
    f.c_currency_id,
    f.amtsourcedr,
    f.amtsourcecr,
    f.amtsource,
    f.amtacctdr,
    f.amtacctcr,
    f.amtacct,
    f.rate,
    f.c_uom_id,
    f.qty,
    f.m_product_id,
    f.c_bpartner_id,
    f.ad_orgtrx_id,
    f.c_locfrom_id,
    f.c_locto_id,
    f.c_salesregion_id,
    f.c_project_id,
    f.c_campaign_id,
    f.c_activity_id,
    f.user1_id,
    f.user2_id,
    f.a_asset_id,
    f.description,
    f.orgvalue,
    f.orgname,
    f.accountvalue,
    f.name,
    f.accounttype,
    f.bpartnervalue,
    f.bpname,
    f.c_bp_group_id,
    f.productvalue,
    f.productname,
    f.upc,
    f.m_product_category_id,
    f.c_projectphase_id,
    f.c_projecttask_id,
    f.c_subacct_id,
    f.userelement1_id,
    f.userelement2_id,
    f.ad_org_description,
    f.ad_org_isactive,
    f.c_elementvalue_ad_org_id,
    f.c_bankaccount_id,
    f.c_elementvalue_c_currency_id,
    f.c_element_id,
    f.c_elementvalue_id,
    f.c_elementvalue_description,
    f.c_elementvalue_isactive,
    f.isbankaccount,
    f.isforeigncurrency,
    f.c_elementvalue_issummary,
    f.c_bp_acqusitioncost,
    f.c_bp_actuallifetimevalue,
    f.c_bp_ad_language,
    f.c_bp_ad_orgbp_id,
    f.c_bp_ad_org_id,
    f.c_bp_bpartner_parent_id,
    f.c_bp_c_dunning_id,
    f.c_bp_c_greeting_id,
    f.c_bp_c_invoiceschedule_id,
    f.c_bp_c_paymentterm_id,
    f.c_bp_created,
    f.c_bp_createdby,
    f.c_bp_c_taxgroup_id,
    f.c_bp_deliveryrule,
    f.c_bp_deliveryviarule,
    f.c_bp_description,
    f.c_bp_dunninggrace,
    f.duns,
    f.c_bp_firstsale,
    f.c_bp_flatdiscount,
    f.c_bp_freightcostrule,
    f.c_bp_invoicerule,
    f.c_bp_isactive,
    f.c_bp_iscustomer,
    f.c_bp_isdiscountprinted,
    f.c_bp_isemployee,
    f.c_bp_ismanufacturer,
    f.c_bp_isonetime,
    f.c_bp_ispotaxexempt,
    f.c_bp_isprospect,
    f.c_bp_issalesrep,
    f.c_bp_issummary,
    f.c_bp_istaxexempt,
    f.c_bp_isvendor,
    f.c_bp_logo_id,
    f.c_bp_m_discountschema_id,
    f.c_bp_m_pricelist_id,
    f.naics,
    f.c_bp_name2,
    f.c_bp_numberemployees,
    f.c_bp_paymentrule,
    f.c_bp_paymentrulepo,
    f.c_bp_po_discountschema_id,
    f.c_bp_po_paymentterm_id,
    f.c_bp_po_pricelist_id,
    f.c_bp_poreference,
    f.c_bp_potentiallifetimevalue,
    f.c_bp_rating,
    f.referenceno,
    f.c_bp_salesrep_id,
    f.c_bp_salesvolume,
    f.c_bp_sendemail,
    f.c_bp_shareofcustomer,
    f.c_bp_shelflifeminpct,
    f.c_bp_so_creditlimit,
    f.c_bp_socreditstatus,
    f.c_bp_so_creditused,
    f.c_bp_so_description,
    f.taxid,
    f.c_bp_totalopenbalance,
    f.c_bp_updated,
    f.c_bp_updatedby,
    f.c_bp_url,
    f.m_product_ad_org_id,
    f.classification,
    f.m_product_copyfrom,
    f.m_product_created,
    f.m_product_createdby,
    f.c_revenuerecognition_id,
    f.c_subscriptiontype_id,
    f.c_taxcategory_id,
    f.m_product_c_uom_id,
    f.m_product_description,
    f.descriptionurl,
    f.discontinued,
    f.discontinuedat,
    f.documentnote,
    f.group1,
    f.group2,
    f.guaranteedays,
    f.guaranteedaysmin,
    f.help,
    f.imageurl,
    f.m_product_isactive,
    f.isdropship,
    f.isexcludeautodelivery,
    f.isinvoiceprintdetails,
    f.ispicklistprintdetails,
    f.ispurchased,
    f.isselfservice,
    f.issold,
    f.isstocked,
    f.m_product_issummary,
    f.isverified,
    f.iswebstorefeatured,
    f.lowlevel,
    f.m_product_m_attributeset_id,
    f.m_product_m_asi_id,
    f.m_freightcategory_id,
    f.m_product_m_locator_id,
    f.m_product_processing,
    f.producttype,
    f.r_mailtext_id,
    f.m_product_salesrep_id,
    f.s_expensetype_id,
    f.shelfdepth,
    f.shelfheight,
    f.shelfwidth,
    f.sku,
    f.s_resource_id,
    f.unitsperpack,
    f.unitsperpallet,
    f.m_product_updated,
    f.m_product_updatedby,
    f.versionno,
    f.volume,
    f.weight,
    t.ad_pinstance_id,
    t.matchcode
   FROM (rv_fact_acct f
     JOIN t_reconciliation t ON ((f.fact_acct_id = t.fact_acct_id)));