APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_VENDORS

Line 4291: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH,PO_VENDORS POV,

4287: 0,
4288: p_sequence + ROWNUM,
4289: substr(l_textline,1,240),
4290: 'PO_SUB_REL_VENDOR_ON_HOLD'
4291: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH,PO_VENDORS POV,
4292: PO_SYSTEM_PARAMETERS PSP
4293: WHERE POR.po_header_id = POH.po_header_id
4294: AND POV.vendor_id = POH.vendor_id
4295: AND POR.po_release_id = p_document_id

Line 5493: from PO_HEADERS_GT POH, po_vendors pov

5489: substr(l_textline,1,240),
5490: 'PO_PDOI_INVALID_VENDOR'
5491: FROM dual
5492: where not exists (select 'Y'
5493: from PO_HEADERS_GT POH, po_vendors pov
5494: WHERE POH.po_header_id = l_agreement_id
5495: AND pov.vendor_id = poh.vendor_id
5496: AND pov.enabled_flag = 'Y'
5497: AND SYSDATE BETWEEN nvl(pov.start_date_active, SYSDATE-1)

Line 7210: FROM PO_HEADERS_GT POH, PO_VENDORS POV, PO_SYSTEM_PARAMETERS PSP

7206: 0,
7207: p_sequence + ROWNUM,
7208: substr(l_textline,1,240),
7209: 'PO_SUB_VENDOR_ON_HOLD'
7210: FROM PO_HEADERS_GT POH, PO_VENDORS POV, PO_SYSTEM_PARAMETERS PSP
7211: WHERE POV.vendor_id = POH.vendor_id
7212: AND POH.po_header_id = p_document_id
7213: AND nvl(PSP.ENFORCE_VENDOR_HOLD_FLAG,'N') = 'Y'
7214: AND nvl(POV.hold_flag,'N') = 'Y';

Line 7788: from PO_HEADERS_GT POH, po_vendors pov

7784: substr(l_textline,1,240),
7785: 'PO_PDOI_INVALID_VENDOR'
7786: FROM dual
7787: where not exists (select 'Y'
7788: from PO_HEADERS_GT POH, po_vendors pov
7789: WHERE POH.po_header_id = p_document_id
7790: AND pov.vendor_id = poh.vendor_id
7791: AND pov.enabled_flag = 'Y'
7792: AND SYSDATE BETWEEN nvl(pov.start_date_active, SYSDATE-1)