DBA Data[Home] [Help]

APPS.PO_SOURCING2_SV dependencies on PO_LINES_ALL

Line 378: po_lines_all pl

374: pl.po_header_id
375: INTO l_source_document_type,
376: l_source_document_header_id
377: FROM po_headers_all ph,
378: po_lines_all pl
379: WHERE ph.po_header_id = pl.po_header_id
380: AND pl.po_line_id = p_po_line_id;
381: ELSE
382: SELECT ph.type_lookup_code,

Line 519: FROM po_lines_all pl -- GA FPI

515:
516: if (l_price is null) then /* */
517: SELECT pl.unit_price
518: INTO l_price /* */
519: FROM po_lines_all pl -- GA FPI
520: WHERE pl.po_line_id = p_po_line_id;
521:
522: x_price_break_id := null; -- SERVICES FPJ
523: end if;

Line 1054: UPDATE po_lines_all

1050: g_user_id number := fnd_global.user_id;
1051:
1052: BEGIN
1053:
1054: UPDATE po_lines_all
1055: SET unit_price = p_price,
1056: base_unit_price = p_base_unit_price, --
1057: from_line_location_id = p_from_line_location_id, --
1058: last_update_date = sysdate,