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