APPS.PO_COMPARE_REVISIONS dependencies on PO_LINES

Line 468: * p_line_id Unique identifier for PO line in PO_LINES table.

464: * PURPOSE
465: * Resolves the source quotation PO line number.
466: *
467: * ARGUMENTS
468: * p_line_id Unique identifier for PO line in PO_LINES table.
469: *
470: * NOTES
471: * Return NULL if no matching records were found.
472: *

Line 479: v_line_num po_lines.line_num%TYPE;

475: ********************************************************************/
476: FUNCTION get_source_quotation_line( p_line_id in number )
477: RETURN VARCHAR2 AS
478:
479: v_line_num po_lines.line_num%TYPE;
480: v_progress varchar2(3);
481:
482: BEGIN
483:

Line 488: FROM po_lines

484: v_progress := '110';
485:
486: SELECT line_num
487: INTO v_line_num
488: FROM po_lines
489: WHERE po_line_id = p_line_id;
490:
491: RETURN v_line_num;
492:

Line 1870: p_line_from in po_lines_archive%ROWTYPE,

1866: * agreed, and amount agreed.
1867: * 08-SEP-97 Rami Haddad Compare closed code
1868: ********************************************************************/
1869: PROCEDURE compare_lines(
1870: p_line_from in po_lines_archive%ROWTYPE,
1871: p_line_to in po_lines_archive%ROWTYPE,
1872: p_sequence IN NUMBER
1873: ) AS
1874:

Line 1871: p_line_to in po_lines_archive%ROWTYPE,

1867: * 08-SEP-97 Rami Haddad Compare closed code
1868: ********************************************************************/
1869: PROCEDURE compare_lines(
1870: p_line_from in po_lines_archive%ROWTYPE,
1871: p_line_to in po_lines_archive%ROWTYPE,
1872: p_sequence IN NUMBER
1873: ) AS
1874:
1875: /*

Line 2617: from po_lines_all

2613: /* Bug 2201739, we should fetch item_id from line level */
2614:
2615: select line_num, item_id
2616: into c_line_num, c_item_id
2617: from po_lines_all
2618: where po_line_id = p_loc_to.po_line_id;
2619:
2620: v_progress := '600';
2621:

Line 3016: from po_lines_all

3012: --get the line number using line id
3013:
3014: select line_num
3015: into c_line_num
3016: from po_lines_all
3017: where po_line_id = p_dist_to.po_line_id;
3018:
3019: --get the shipment number using line location id
3020: