DBA Data[Home] [Help]

APPS.PO_SOURCING2_SV dependencies on PO_LINES_ALL

Line 481: po_lines_all pl

477: pl.po_header_id
478: INTO l_source_document_type,
479: l_source_document_header_id
480: FROM po_headers_all ph,
481: po_lines_all pl
482: WHERE ph.po_header_id = pl.po_header_id
483: AND pl.po_line_id = p_po_line_id;
484: ELSE
485: --

Line 628: FROM po_lines_all pl -- GA FPI

624:
625: IF (l_price IS NULL) THEN /* */
626: SELECT pl.unit_price
627: INTO l_price /* */
628: FROM po_lines_all pl -- GA FPI
629: WHERE pl.po_line_id = p_po_line_id;
630:
631: x_price_break_id := NULL; -- SERVICES FPJ
632: END IF;

Line 1272: UPDATE po_lines_all

1268: g_user_id NUMBER := fnd_global.user_id;
1269:
1270: BEGIN
1271:
1272: UPDATE po_lines_all
1273: SET unit_price = p_price,
1274: base_unit_price = p_base_unit_price, --
1275: from_line_location_id = p_from_line_location_id, --
1276: last_update_date = SYSDATE,