Cost Management - EBS (MOSC)

MOSC Banner

Need query for PO drill down to GL

edited Sep 12, 2019 8:55AM in Cost Management - EBS (MOSC) 3 commentsAnswered

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",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center