APPS.PO_TOTALS_PO_SV dependencies on PO_LINE_LOCATIONS_ARCHIVE

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: ;