[Home] [Help]
260: po_headers_all poh -- 5684820
261: /*
262: Bug fix for 2687718.
263: Added QUOTATION in the WHERE clause to ensure that pricing works when
264: a Standard PO is sourced to a Quotation through the Supplier Catalog.
265: */
266: WHERE pll.shipment_type in ('PRICE BREAK', 'QUOTATION')
267: AND pll.po_line_id = p_po_line_id
268: AND pll.po_header_id = poh.po_header_id -- 5684820
825: FROM po_line_locations_all pll -- GA FPI
826: /*
827: Bug fix for 2687718.
828: Added QUOTATION in the WHERE clause to ensure that pricing works when
829: a Standard PO is sourced to a Quotation through the Supplier Catalog.
830: */
831: WHERE pll.shipment_type in ('PRICE BREAK', 'QUOTATION')
832: AND pll.po_line_id = x_po_line_id;
833:
1096: /*===========================================================================
1097:
1098: PROCEDURE NAME: get_min_shipment_num()
1099:
1100: This procedure gets the minimum shipment number of a Standard PO line
1101: ===========================================================================*/
1102: PROCEDURE get_min_shipment_num(p_po_line_id IN NUMBER,
1103: x_min_shipment_num OUT NOCOPY NUMBER) IS
1104: BEGIN
1118: /*===========================================================================
1119:
1120: PROCEDURE NAME: get_shipment_price()
1121:
1122: This procedure prices a Standard PO based on its source document reference.
1123: ===========================================================================*/
1124:
1125: --
1126: PROCEDURE get_shipment_price