in my report i want join gl to pay

what tables i will use to join

هو اسم التيبل GL_IMPORT_REFERENCES

شوف الكوري دي ممكن تساعدك

SELECT DISTINCT
FND_FLEX_EXT.GET_SEGS('SQLGL','GL#',50308, XLA.CODE_COMBINATION_ID) ACC_NAME ,
GET_ACCOUNT_NAME(XLA.CODE_COMBINATION_ID, 50308) ACC_DESC ,
INV.INVOICE_NUM AS TRANSACTION_NUMBER,
JH.JE_CATEGORY AS CATEGORY,
JH.JE_SOURCE AS SOURCE,
JH.DOC_SEQUENCE_VALUE AS GL_VOUCHER_NUMBER,
INV.DOC_SEQUENCE_VALUE AS AP_VOUCHER_NUMBER ,
JL.PERIOD_NAME AS PERIOD_NAME,
inv.INVOICE_DATE as invoice_date,
JL.EFFECTIVE_DATE AS GL_DATE,
INV.DESCRIPTION AS DESCRIPTION,
LED.NAME  AS LEDGER_NAME,
JH.CURRENCY_CODE CURRENCY,
JH.CURRENCY_CODE,
XLA.ENTERED_CR CURRENCY_CR,
XLA.ENTERED_DR CURRENCY_DR,
XLA.ACCOUNTED_CR CR,
XLA.ACCOUNTED_DR DR,
JH.ACTUAL_FLAG,
INV.INVOICE_TYPE_LOOKUP_CODE EVENT_CLASS,
VEN.VENDOR_NAME VENDOR_NAME,
VEN.SEGMENT1

FROM
GL_JE_LINES   JL,
GL_JE_HEADERS   JH,
GL_IMPORT_REFERENCES JR,
AP_INVOICES_ALL INV,
PO_VENDORS VEN,
GL_LEDGERS LED,
XLA_AE_LINES XLA,
GL_CODE_COMBINATIONS CC
WHERE JH.JE_HEADER_ID =JR.JE_HEADER_ID
AND JL.JE_LINE_NUM=JR.JE_LINE_NUM
AND JH.JE_CATEGORY<>'1'
AND JH.JE_HEADER_ID =JL.JE_HEADER_ID
AND JR.SUBLEDGER_DOC_SEQUENCE_VALUE =INV.DOC_SEQUENCE_VALUE
AND JH.ACTUAL_FLAG='A'
AND INV.VENDOR_ID=VEN.VENDOR_ID
AND LED.LEDGER_ID =JL.LEDGER_ID
AND XLA.GL_SL_LINK_ID=JR.GL_SL_LINK_ID
AND JH.JE_SOURCE<>'Receivables'
AND XLA.CODE_COMBINATION_ID=CC.CODE_COMBINATION_ID