Need query for PO drill down to GL
Hi,
I am building a query for Gl drill down for the JE_SOURCES to PO,AP,WIP,Inventory,Cost Management
But getting duplicate values when adding the PO Number.
Not sure what is missed here. I tried with subquery for gettingPO number but anyhow getting duplicate values
SELECT DISTINCT
gjl.effective_date,
glcc.concatenated_segments segments,
gjl.period_name,
gjh.name journal_name,
gjh.je_source journal_source,
gjh.je_category journal_category,
initcap(gjl.description) "JE line Description",
--pha.segment1,
-- (select distinct po.segment1 from apps.po_headers_all po where po.po_header_id=poh.po_header_id and po.po_header_id=pod.po_header_id) "Purchase Order Number",