Link between po and xla tables.po to gl query in r12

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 r12

Join 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