DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 295: po_lines_draft_all draft_lines,

291: FND_API.g_FALSE
292: FROM po_line_locations_interface intf_locs,
293: po_lines_interface intf_lines,
294: po_headers_interface intf_headers,
295: po_lines_draft_all draft_lines,
296: po_headers_draft_all draft_headers,
297: po_headers_all txn_headers,
298: po_doc_style_headers pdsh -- Bug#16751944
299: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id

Line 1236: UPDATE po_lines_draft_all draft_lines

1232:
1233: FORALL i IN 1..p_po_line_id_tbl.COUNT
1234: --Bug# 10607851 : Included the secondary quantity in update statment to sum up at line level
1235: -- from line locations level
1236: UPDATE po_lines_draft_all draft_lines
1237: SET (amount, quantity,secondary_quantity) =
1238: (select sum(Decode(Nvl(payment_type,'DELIVERY'),'RATE',Nvl(quantity,0)*Nvl(price_override,0),amount)),
1239: sum(Decode(Nvl(payment_type,'DELIVERY'),'RATE',NULL,quantity)),
1240: sum(secondary_quantity)