Link between po and xla tables.po to gl query in r12
This below query providing all information's from Po to GL. This is the complete XLA information's from PO and XLA tables. In this query you can get Link between po and xla and po to gl query in r12Join between po and gl
select
poh.segment1 po_number, pol.line_num,
nvl(poll.price_override,pol.unit_price)
Unit_price, pod.quantity_ordered, pod.quantity_delivered, pod.quantity_billed,
pod.quantity_cancelled,
xdl.ACCOUNTING_LINE_CODE, XDL.LINE_DEFINITION_CODE,
XDL.EVENT_CLASS_CODE,poh.org_id,poll.shipment_num, por.release_num, pod.distribution_num,
xal.accounted_dr, xal.accounted_cr,
jeh.ledger_id, jeb.name, jeb.creation_date,
jeh.je_source, jeh.je_category,
glcc.segment1, glcc.segment2, glcc.segment3,
glcc.segment4, glcc.segment5, glcc.segment6,
jel.je_line_num, nvl(jel.accounted_dr,0)
accounted_dr, nvl(jel.accounted_cr,0) accounted_cr
from
apps.po_headers_all poh,
apps.po_lines_all pol,
apps.po_line_locations_all poll,
apps.po_distributions_all pod,
apps.po_releases_all por,
apps.xla_distribution_links xdl,
apps.xla_ae_lines xal,
APPS.GL_IMPORT_REFERENCES gif,
apps.gl_je_lines jel,
apps.gl_je_headers jeh,
apps.gl_je_batches jeb,
apps.gl_code_combinations glcc
where 1=1
and xdl.AE_LINE_NUM = xal.AE_LINE_NUM
AND XDL.AE_HEADER_ID = XAL.AE_HEADER_ID
and xal.gl_sl_link_table = gif.gl_sl_link_table
and xal.gl_sl_link_id = gif.gl_sl_link_id
and gif.je_header_id = jel.je_header_id
and gif.je_line_num = jel.je_line_num
and jel.code_combination_id = glcc.code_combination_id
and jel.je_header_id = jeh.je_header_id
and jeh.je_batch_id = jeb.je_batch_id
AND XDL.SOURCE_DISTRIBUTION_TYPE ='PO_DISTRIBUTIONS_ALL'
and poh.segment1='1234444' --PO
NUMBER
AND XDL.APPLICATION_ID = 201
AND pod.po_distribution_id = XDL.SOURCE_DISTRIBUTION_ID_NUM_1
and pod.line_location_id = poll.line_location_id
and poll.po_line_id = pol.po_line_id
and pol.po_header_id = poh.po_header_id
and pod.po_release_id = por.po_release_id(+)
Link between po and xla tables.po to gl query in r12
