DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1134: FROM po_line_locations_draft_all

1130: FORALL i IN 1..p_po_line_id_tbl.COUNT
1131: UPDATE po_lines_draft_all draft_lines
1132: SET (amount, quantity) =
1133: (select sum(amount), sum(quantity)
1134: FROM po_line_locations_draft_all
1135: WHERE po_line_id = draft_lines.po_line_id
1136: AND draft_id = draft_lines.draft_id)
1137: WHERE po_line_id = p_po_line_id_tbl(i)
1138: AND draft_id = p_draft_id_tbl(i);