36: PV2.vendor_name) VENDOR_NAME,
37: NVL2(PHI.document_num, 'Y', 'N') DOC_NUM_PROVIDED --bug5028275
38: FROM po_headers_interface PHI,
39: po_headers_draft_all PHDA,
40: po_headers_all POH,
41: po_drafts DFT,
42: po_vendors PV1,
43: po_vendors PV2
44: WHERE PHI.draft_id = DFT.draft_id