46: po_headers_all POH,
47: po_drafts DFT,
48: po_vendors PV1,
49: po_vendors PV2
50: WHERE DFT.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id
51: AND DFT.draft_id = PHDA.draft_id(+)
52: AND DFT.document_id = PHDA.po_header_id(+)
53: AND PHDA.vendor_id = PV1.vendor_id(+)
54: AND DFT.document_id = POH.po_header_id(+)
52: AND DFT.document_id = PHDA.po_header_id(+)
53: AND PHDA.vendor_id = PV1.vendor_id(+)
54: AND DFT.document_id = POH.po_header_id(+)
55: AND POH.vendor_id = PV2.vendor_id(+)
56: AND PHI.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
57:
58:
59: SUBTYPE doc_row_type IS c_doc%ROWTYPE;
60: