Links for AP - SLA / XLA - GL

Select Distinct Xal.Accounting_Date Gl_Date,Xah.Je_Category_Name Tr_Type, Ap.Segment1 Vendor_Num, Ap.Vendor_Name,Pvs.Vendor_Site_Code As Vendor_Site_Name ,
Aia.Doc_Sequence_Value Voucher_No, Aia.Invoice_Num, Aia.Invoice_Date, Xal.Currency_Code, Xal.Entered_Dr,Xal.Entered_Cr,Xal.Accounted_Dr,Xal.Accounted_Cr ,
Replace(Xal.Description, Chr(10),' ') Remarks
 From
Apps.Gl_Import_References Gir,
Apps.Gl_Je_Headers Gh,
Apps.Gl_Je_Lines Gl,
Apps.Xla_Ae_Lines Xal ,
Apps.Xla_Ae_Headers Xah,
Apps.Xla_Transaction_Entities_Upg Xte,
Apps.Ap_Invoices_All Aia,
Apps.Ap_Suppliers Ap,
Apps.Po_Vendor_Sites_All Pvs,
Apps.Gl_Code_Combinations Gcc
Where
Xal.Gl_Sl_Link_Id=Gir.Gl_Sl_Link_Id
And Xal.Ae_Header_Id = Xah.Ae_Header_Id
And Gir.Je_Header_Id = Gl.Je_Header_Id
And Gir.Je_Line_Num = Gl.Je_Line_Num
And Gl.Je_Header_Id = Gh.Je_Header_Id
And Xah.Entity_Id = Xte.Entity_Id
And Xte.Source_Id_Int_1 = Aia.Invoice_Id
And Xte.Security_Id_Int_1 = Aia.Org_Id
And Aia.Vendor_Id = Ap.Vendor_Id
And Ap.Vendor_Id = Pvs.Vendor_Id
And Aia.Vendor_Site_Id = Pvs.Vendor_Site_Id
And Gcc.Code_Combination_Id = Xal.Code_Combination_Id
And Gcc.Code_Combination_Id = Gl.Code_Combination_Id
And Aia.Org_Id = Nvl(:Org, Aia.Org_Id)
and xal.source_table in ('AP_INVOICES','AP_CHECKS')
And Nvl(Xah.Gl_Transfer_Status_Code,'N') = 'Y';