DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 508: DELETE FROM po_line_locations_draft_all

504:
505: d_position := 10;
506:
507: FORALL i IN 1..l_po_line_id_tbl.COUNT
508: DELETE FROM po_line_locations_draft_all
509: WHERE draft_id = p_draft_id
510: AND po_line_id = l_po_line_id_tbl(i);
511:
512: d_position := 20;

Line 541: FROM po_line_locations_draft_all PLLD

537: DELETE FROM po_price_diff_draft PPDD
538: WHERE draft_id = p_draft_id
539: AND entity_type = 'PRICE BREAK'
540: AND EXISTS (SELECT 1
541: FROM po_line_locations_draft_all PLLD
542: WHERE PLLD.draft_id = p_draft_id
543: AND PLLD.po_line_id = l_po_line_id_tbl(i)
544: AND PLLD.line_location_id = PPDD.entity_id
545: UNION ALL