DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_VENDOR_SITES

Line 3701: from PO_HEADERS_GT POH, po_vendor_sites povs

3697: substr(l_textline,1,240),
3698: 'PO_PDOI_INVALID_VENDOR_SITE'
3699: FROM dual
3700: where not exists (select 'Y'
3701: from PO_HEADERS_GT POH, po_vendor_sites povs
3702: WHERE POH.po_header_id = l_agreement_id
3703: AND povs.vendor_site_id = poh.vendor_site_id
3704: AND nvl(povs.rfq_only_site_flag,'N') <> 'Y'
3705: AND povs.purchasing_site_flag = 'Y'

Line 5496: from PO_HEADERS_GT POH, po_vendor_sites povs

5492: substr(l_textline,1,240),
5493: 'PO_PDOI_INVALID_VENDOR_SITE'
5494: FROM dual
5495: where not exists (select 'Y'
5496: from PO_HEADERS_GT POH, po_vendor_sites povs
5497: WHERE POH.po_header_id = p_document_id
5498: AND povs.vendor_site_id = poh.vendor_site_id
5499: AND nvl(povs.rfq_only_site_flag,'N') <> 'Y'
5500: AND povs.purchasing_site_flag = 'Y'