DBA Data[Home] [Help]

APPS.ITG_X_UTILS dependencies on PO_LINE_LOCATIONS_ALL

Line 33: FROM po_line_locations_all

29:
30: FUNCTION isPoLineApproved(v_po_line_id in Number)
31: RETURN NUMBER as
32: CURSOR getPoLineApproval IS SELECT COUNT(*)
33: FROM po_line_locations_all
34: WHERE po_line_id=v_po_line_id and approved_flag='Y';
35:
36: returnvalue number(10);
37: BEGIN

Line 349: ** from po_line_locations_all for the given po_header_id

345: END signOf;
346:
347: /*
348: ** sumPoLineLocs summarizes the quantity*price_override
349: ** from po_line_locations_all for the given po_header_id
350: **
351: ** Taken from Po_Ip_Oagxml_Pkg.
352: */
353: FUNCTION sumPoLineLocs (

Line 360: FROM po_line_locations_all

356: ) RETURN NUMBER as
357: returnValue NUMBER := 0;
358: CURSOR sumValue IS
359: SELECT sum( quantity * price_override )
360: FROM po_line_locations_all
361: WHERE po_header_id = poHeaderId;
362: CURSOR sumValueRel IS
363: SELECT sum( quantity * price_override )
364: FROM po_line_locations_all

Line 364: FROM po_line_locations_all

360: FROM po_line_locations_all
361: WHERE po_header_id = poHeaderId;
362: CURSOR sumValueRel IS
363: SELECT sum( quantity * price_override )
364: FROM po_line_locations_all
365: WHERE po_header_id = poHeaderId
366: AND po_release_id = poRelease;
367: BEGIN
368: IF poHeaderId IS NOT NULL THEN