AP Inoice track to GL - Printable Version +- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com) +-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html) +--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html) +---- Forum: Oracle Financials (http://www.oraerp.com/forum-2.html) +---- Thread: AP Inoice track to GL (/thread-71190.html)

AP Inoice track to GL - shirfanarshad - 10-24-2014 Select GJH.NAME, GJH.JE_HEADER_ID, GJL.JE_LINE_NUM, aia.INVOICE_ID "Invoice Id",      aia.INVOICE_NUM "Invoice Number",      aia.INVOICE_DATE "Invoice Date",      aia.INVOICE_AMOUNT "Amount",      xal.ENTERED_DR "Entered DR in SLA",      xal.ENTERED_CR "Entered CR in SLA",      xal.ACCOUNTED_DR "Accounted DR in SLA",      xal.ACCOUNTED_CR "Accounted CR in SLA",       gjh.je_source ,      gjl.ENTERED_DR "Entered DR in GL",      gjl.ENTERED_CR "Entered CR in GL",      gjl.ACCOUNTED_DR "Accounted DR in GL",      gjl.ACCOUNTED_CR "Accounted CR in GL",      xal.ACCOUNTING_CLASS_CODE "Accounting Class",      gcc.SEGMENT1||'.'||gcc.SEGMENT2||'.'          ||gcc.SEGMENT3||'.'||gcc.SEGMENT4||'.'          ||gcc.SEGMENT5||'.'||gcc.SEGMENT6||'.'          ||gcc.SEGMENT7 "GL_Code Combination",      aia.INVOICE_CURRENCY_CODE "Inv Curr Code",      aia.PAYMENT_CURRENCY_CODE "Pay Curr Code",      aia.GL_DATE "GL Date",      xah.PERIOD_NAME "Period",      aia.PAYMENT_METHOD_CODE "Payment Method",      aia.VENDOR_ID "Vendor Id",      aps.VENDOR_NAME "Vendor Name",      xah.JE_CATEGORY_NAME "JE Category Name" FROM      apps.ap_invoices_all aia,      xla.xla_transaction_entities XTE,      apps.xla_events xev,      apps.xla_ae_headers XAH,      apps.xla_ae_lines XAL,      apps.GL_IMPORT_REFERENCES gir,      apps.gl_je_headers gjh,      apps.gl_je_lines  gjl,      apps.gl_code_combinations gcc,      apps.ap_suppliers aps  Where aia.INVOICE_ID = xte.source_id_int_1 and xev.entity_id= xte.entity_id      and xah.entity_id= xte.entity_id      and xah.event_id= xev.event_id      and XAH.ae_header_id = XAL.ae_header_id --     and XAH.gl_transfer_status_code= 'Y'      and XAL.GL_SL_LINK_ID=gir.GL_SL_LINK_ID      and gir.GL_SL_LINK_TABLE = xal.GL_SL_LINK_TABLE      and gjl.JE_HEADER_ID=gjh.JE_HEADER_ID      and gjh.JE_HEADER_ID=gir.JE_HEADER_ID      and gjl.JE_HEADER_ID=gir.JE_HEADER_ID      and gir.JE_LINE_NUM=gjl.JE_LINE_NUM      and gcc.CODE_COMBINATION_ID=XAL.CODE_COMBINATION_ID      and gcc.CODE_COMBINATION_ID=gjl.CODE_COMBINATION_ID     and aia.VENDOR_ID=aps.VENDOR_ID and aia.INVOICE_DATE between :Invoice_from and :invoice_to --   and gcc.segment1 = 01  --     and gjh.STATUS='P'      and gjh.Actual_flag='A'   RE: AP Inoice track to GL - viggora - 10-16-2019 audiobookkeeper.rucottagenet.rueyesvision.rueyesvisions.comfactoringfee.rufilmzones.rugadwall.rugaffertape.rugageboard.rugagrule.rugallduct.rugalvanometric.rugangforeman.rugangwayplatform.rugarbagechute.rugardeningleave.rugascautery.rugashbucket.rugasreturn.rugatedsweep.rugaugemodel.rugaussianfilter.rugearpitchdiameter.ru geartreating.rugeneralizedanalysis.rugeneralprovisions.rugeophysicalprobe.rugeriatricnurse.rugetintoaflap.rugetthebounce.ruhabeascorpus.ruhabituate.ruhackedbolt.ruhackworker.ruhadronicannihilation.ruhaemagglutinin.ruhailsquall.ruhairysphere.ruhalforderfringe.ruhalfsiblings.ruhallofresidence.ruhaltstate.ruhandcoding.ruhandportedhead.ruhandradar.ruhandsfreetelephone.ru hangonpart.ruhaphazardwinding.ruhardalloyteeth.ruhardasiron.ruhardenedconcrete.ruharmonicinteraction.ruhartlaubgoose.ruhatchholddown.ruhaveafinetime.ruhazardousatmosphere.ruheadregulator.ruheartofgold.ruheatageingresistance.ruheatinggas.ruheavydutymetalcutting.rujacketedwall.rujapanesecedar.rujibtypecrane.rujobabandonment.rujobstress.rujogformation.rujointcapsule.rujointsealingmaterial.ru journallubricator.rujuicecatcher.rujunctionofchannels.rujusticiablehomicide.rujuxtapositiontwin.rukaposidisease.rukeepagoodoffing.rukeepsmthinhand.rukentishglory.rukerbweight.rukerrrotation.rukeymanassurance.rukeyserum.rukickplate.rukillthefattedcalf.rukilowattsecond.rukingweakfish.rukinozones.rukleinbottle.rukneejoint.ruknifesethouse.ruknockonatom.ruknowledgestate.ru kondoferromagnet.rulabeledgraph.rulaborracket.rulabourearnings.rulabourleasing.rulaburnumtree.rulacingcourse.rulacrimalpoint.rulactogenicfactor.rulacunarycoefficient.ruladletreatediron.rulaggingload.rulaissezaller.rulambdatransition.rulaminatedmaterial.rulammasshoot.rulamphouse.rulancecorporal.rulancingdie.rulandingdoor.rulandmarksensor.rulandreform.rulanduseratio.ru languagelaboratory.rulargeheart.rulasercalibration.rulaserlens.rulaserpulse.rulaterevent.rulatrinesergeant.rulayabout.ruleadcoating.ruleadingfirm.rulearningcurve.ruleaveword.rumachinesensible.rumagneticequator.rumagnetotelluricfield.rumailinghouse.rumajorconcern.rumammasdarling.rumanagerialstaff.rumanipulatinghand.rumanualchoke.rumedinfobooks.rump3lists.ru nameresolution.runaphtheneseries.runarrowmouthed.runationalcensus.runaturalfunctor.runavelseed.runeatplaster.runecroticcaries.runegativefibration.runeighbouringrights.ruobjectmodule.ruobservationballoon.ruobstructivepatent.ruoceanmining.ruoctupolephonon.ruofflinesystem.ruoffsetholder.ruolibanumresinoid.ruonesticket.rupackedspheres.rupagingterminal.rupalatinebones.rupalmberry.ru papercoating.ruparaconvexgroup.ruparasolmonoplane.ruparkingbrake.rupartfamily.rupartialmajorant.ruquadrupleworm.ruqualitybooster.ruquasimoney.ruquenchedspark.ruquodrecuperet.rurabbetledge.ruradialchaser.ruradiationestimator.rurailwaybridge.rurandomcoloration.rurapidgrowth.rurattlesnakemaster.rureachthroughregion.rureadingmagnifier.rurearchain.rurecessioncone.rurecordedassignment.ru rectifiersubstation.ruredemptionvalue.rureducingflange.rureferenceantigen.ruregeneratedprotein.rureinvestmentplan.rusafedrilling.rusagprofile.rusalestypelease.rusamplinginterval.rusatellitehydrology.ruscarcecommodity.ruscrapermat.ruscrewingunit.ruseawaterpump.rusecondaryblock.rusecularclergy.ruseismicefficiency.ruselectivediffuser.rusemiasphalticflux.rusemifinishmachining.ruspicetrade.ruspysale.ru stungun.rutacticaldiameter.rutailstockcenter.rutamecurve.rutapecorrection.rutappingchuck.rutaskreasoning.rutechnicalgrade.rutelangiectaticlipoma.rutelescopicdamper.rutemperateclimate.rutemperedmeasure.rutenementbuilding.ruultramaficrock.ruultraviolettesting.ru RE: AP Inoice track to GL - viggora - 12-24-2019 инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо