DBA Data[Home] [Help]

APPS.PO_TOTALS_PO_SV dependencies on STANDARD

Line 31: AND shipment_type IN ('STANDARD','PLANNED','BLANKET');

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:
34: RETURN (X_po_total);
35:

Line 72: AND shipment_type IN ('STANDARD','PLANNED','BLANKET')

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
75: max( plla2.revision_num )
76: FROM

Line 125: AND shipment_type IN ('STANDARD','PLANNED','BLANKET')

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
128: max( plla2.revision_num )
129: FROM