DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINES_DRAFT_ALL

Line 498: DELETE FROM po_lines_draft_all

494: IF (PO_LOG.d_proc) THEN
495: PO_LOG.proc_begin(d_module);
496: END IF;
497:
498: DELETE FROM po_lines_draft_all
499: WHERE draft_id = p_draft_id
500: AND change_accepted_flag = PO_DRAFTS_PVT.g_chg_accepted_flag_NOTIFY
501: RETURNING po_line_id
502: BULK COLLECT

Line 2209: po_lines_draft_all PLD

2205: x_lines.effective_date_tbl,
2206: x_lines.expiration_date_tbl
2207: FROM po_headers_interface PHI,
2208: po_lines_interface PLI,
2209: po_lines_draft_all PLD
2210: WHERE PHI.interface_header_id = p_doc_rec.interface_header_id
2211: AND PHI.interface_header_id = PLI.interface_header_id
2212: AND PHI.draft_id = PLD.draft_id
2213: AND PLI.po_line_id = PLD.po_line_id