DBA Data[Home] [Help]

APPS.PO_SOURCING2_SV dependencies on STANDARD

Line 343: a Standard PO is sourced to a Quotation through the Supplier Catalog.

339: po_headers_all poh -- 5684820
340: /*
341: Bug fix for 2687718.
342: Added QUOTATION in the WHERE clause to ensure that pricing works when
343: a Standard PO is sourced to a Quotation through the Supplier Catalog.
344: */
345: WHERE pll.shipment_type IN ('PRICE BREAK', 'QUOTATION')
346: AND pll.po_line_id = p_po_line_id
347: AND pll.po_header_id = poh.po_header_id -- 5684820

Line 1047: a Standard PO is sourced to a Quotation through the Supplier Catalog.

1043: FROM po_line_locations_all pll -- GA FPI
1044: /*
1045: Bug fix for 2687718.
1046: Added QUOTATION in the WHERE clause to ensure that pricing works when
1047: a Standard PO is sourced to a Quotation through the Supplier Catalog.
1048: */
1049: WHERE pll.shipment_type IN ('PRICE BREAK', 'QUOTATION')
1050: AND pll.po_line_id = x_po_line_id;
1051:

Line 1318: This procedure gets the minimum shipment number of a Standard PO line

1314: /*===========================================================================
1315:
1316: PROCEDURE NAME: get_min_shipment_num()
1317:
1318: This procedure gets the minimum shipment number of a Standard PO line
1319: ===========================================================================*/
1320: PROCEDURE get_min_shipment_num(p_po_line_id IN NUMBER,
1321: x_min_shipment_num OUT NOCOPY NUMBER) IS
1322: BEGIN

Line 1340: This procedure prices a Standard PO based on its source document reference.

1336: /*===========================================================================
1337:
1338: PROCEDURE NAME: get_shipment_price()
1339:
1340: This procedure prices a Standard PO based on its source document reference.
1341: ===========================================================================*/
1342:
1343: --
1344: PROCEDURE get_shipment_price