APPS.PO_PRICE_BREAK_GRP dependencies on PO_LINES_ALL

Line 26: p_po_line_num IN PO_LINES_ALL.line_num%TYPE

22: ) RETURN PO_HEADERS_ALL.rate%TYPE;
23:
24: FUNCTION get_line_price -- <2694908>
25: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
26: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
27: ) RETURN PO_LINES_ALL.unit_price%TYPE;
28:
29: /*===========================================================================*/
30: /*============================ BODY (Overloaded) ============================*/

Line 27: ) RETURN PO_LINES_ALL.unit_price%TYPE;

23:
24: FUNCTION get_line_price -- <2694908>
25: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
26: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
27: ) RETURN PO_LINES_ALL.unit_price%TYPE;
28:
29: /*===========================================================================*/
30: /*============================ BODY (Overloaded) ============================*/
31: /*===========================================================================*/

Line 250: , po_lines_all pol -- FPI GA

246: null, pol.unit_meas_lookup_code,
247: poll.unit_meas_lookup_code)
248: , poll.line_location_id -- SERVICES FPJ
249: FROM po_headers_all poh -- FPI GA
250: , po_lines_all pol -- FPI GA
251: , po_line_locations_all poll -- FPI GA
252: WHERE poh.po_header_id = p_source_document_header_id
253: and poh.po_header_id = pol.po_header_id
254: and pol.line_num = p_source_document_line_num

Line 406: po_lines_all pl

402: pl.po_line_id
403: INTO l_source_document_type,
404: l_source_document_line_id
405: FROM po_headers_all ph,
406: po_lines_all pl
407: WHERE ph.po_header_id = p_source_document_header_id
408: AND pl.po_header_id(+) = ph.po_header_id
409: AND pl.line_num(+) = p_source_document_line_num;
410:

Line 1137: p_po_line_num IN PO_LINES_ALL.line_num%TYPE

1133: =============================================================================*/
1134: FUNCTION get_line_price
1135: (
1136: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
1137: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1138: )
1139: RETURN PO_LINES_ALL.unit_price%TYPE
1140: IS
1141: x_unit_price PO_LINES_ALL.unit_price%TYPE;

Line 1139: RETURN PO_LINES_ALL.unit_price%TYPE

1135: (
1136: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
1137: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1138: )
1139: RETURN PO_LINES_ALL.unit_price%TYPE
1140: IS
1141: x_unit_price PO_LINES_ALL.unit_price%TYPE;
1142:
1143: BEGIN

Line 1141: x_unit_price PO_LINES_ALL.unit_price%TYPE;

1137: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1138: )
1139: RETURN PO_LINES_ALL.unit_price%TYPE
1140: IS
1141: x_unit_price PO_LINES_ALL.unit_price%TYPE;
1142:
1143: BEGIN
1144:
1145: SELECT unit_price

Line 1147: FROM po_lines_all

1143: BEGIN
1144:
1145: SELECT unit_price
1146: INTO x_unit_price
1147: FROM po_lines_all
1148: WHERE po_header_id = p_po_header_id
1149: AND line_num = p_po_line_num;
1150:
1151: return (x_unit_price);