DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 279: po_lines_draft_all draft_lines,

275: FND_API.g_FALSE
276: FROM po_line_locations_interface intf_locs,
277: po_lines_interface intf_lines,
278: po_headers_interface intf_headers,
279: po_lines_draft_all draft_lines,
280: po_headers_draft_all draft_headers,
281: po_headers_all txn_headers
282: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
283: AND intf_lines.interface_header_id = intf_headers.interface_header_id

Line 1131: UPDATE po_lines_draft_all draft_lines

1127: PO_LOG.proc_begin(d_module);
1128: END IF;
1129:
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