Procurement - EBS (MOSC)

MOSC Banner

Query to get purchase order blanket release details

Hello Experts,


Oracle Apps: 12.2.4

DB Version: 11.2.0.1

We are trying to get PO blanket release details but it seems some conditions are not proper and the records are getting increased,

Query:

SELECT SUM (NVL (pll.QUANTITY, 0) * NVL (pol.UNIT_PRICE, 0))

      "PO Releases Total Value"

 FROM apps.PO_HEADERS_ALL     poh,

    apps.PO_LINES_ALL      pol,

    apps.hr_locations      hl,

    apps.po_releases_all    pr,

    apps.po_line_locations_all pll

 WHERE   1 = 1

    AND poh.org_id = <org_id>

    AND poh.type_lookup_code = 'BLANKET'

    AND poh.po_header_id = pol.po_header_id

    AND poh.org_id = pol.org_id

    AND poh.ship_to_location_id = hl.ship_to_location_id

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