DBA Data[Home] [Help]

APPS.PON_SUPPLIER_RESEARCH_PVT dependencies on PO_RELEASES_ALL

Line 323: po_releases_all por,

319: SELECT COUNT(*) total_po_releases
320: INTO l_tot_po_rel
321: FROM po_vendors pv,
322: hz_parties hp,
323: po_releases_all por,
324: po_headers poh
325: WHERE hp.party_id = p_tp_id
326: AND poh.PO_HEADER_ID = por.PO_HEADER_ID
327: AND por.release_type = 'BLANKET'

Line 370: po_releases_all por,

366: -- Fetch the total purchasing releases
367: SELECT COUNT(*) total_po_releases
368: INTO l_tot_po_rel
369: FROM po_vendors pv,
370: po_releases_all por,
371: po_headers poh
372: WHERE pv.vendor_id = p_vendor_id
373: AND poh.vendor_id = pv.vendor_id
374: AND poh.PO_HEADER_ID = por.PO_HEADER_ID