APPS.PO_TOTALS_PO_SV dependencies on PO_LINE_LOCATIONS

Line 29: FROM po_line_locations

25: SELECT round(((nvl(SUM((quantity - quantity_cancelled) * price_override),0)
26: * x_min_unit) / x_min_unit),
27: x_precision)
28: into X_po_total
29: FROM po_line_locations
30: WHERE po_header_id = X_header_id
31: AND shipment_type IN ('STANDARD','PLANNED','BLANKET');
32:
33:

Line 70: FROM po_line_locations_archive plla1

66: SELECT round(((nvl(SUM((quantity - quantity_cancelled) * price_override),0)
67: * x_min_unit) / x_min_unit),
68: x_precision)
69: into X_po_total
70: FROM po_line_locations_archive plla1
71: WHERE po_header_id = X_header_id
72: AND shipment_type IN ('STANDARD','PLANNED','BLANKET')
73: AND revision_num = (
74: SELECT

Line 77: po_line_locations_archive plla2

73: AND revision_num = (
74: SELECT
75: max( plla2.revision_num )
76: FROM
77: po_line_locations_archive plla2
78: WHERE
79: plla2.revision_num <= X_revision_num
80: AND plla2.line_location_id = plla1.line_location_id )
81: ;

Line 123: FROM po_line_locations_archive plla1

119: SELECT round(((nvl(SUM((quantity - quantity_cancelled) * price_override),0)
120: * x_min_unit) / x_min_unit),
121: x_precision)
122: into X_po_total
123: FROM po_line_locations_archive plla1
124: WHERE po_release_id = X_release_id
125: AND shipment_type IN ('STANDARD','PLANNED','BLANKET')
126: AND revision_num = (
127: SELECT

Line 130: po_line_locations_archive plla2

126: AND revision_num = (
127: SELECT
128: max( plla2.revision_num )
129: FROM
130: po_line_locations_archive plla2
131: WHERE
132: plla2.revision_num <= X_revision_num
133: AND plla2.line_location_id = plla1.line_location_id )
134: ;

Line 172: FROM po_line_locations

168: SELECT round(((nvl(SUM((quantity - quantity_cancelled) * price_override),0)
169: * x_min_unit) / x_min_unit),
170: x_precision)
171: into X_release_total
172: FROM po_line_locations
173: WHERE po_release_id = X_release_id;
174:
175:
176: RETURN (X_release_total);