[Home] [Help]
64: where pll.secondary_unit_of_measure is not null
65: AND pll.po_header_id = pll.po_header_id
66: AND pll.po_line_id = pl.po_line_id
67: AND pll.ship_to_organization_id = mp.organization_id
68: AND pll.shipment_type in ('STANDARD', 'PLANNED', 'BLANKET')
69: AND (
70: (nvl(pll.secondary_quantity_shipped,0) = 0 and nvl(pll.quantity_shipped,0) <> 0)
71: OR
72: (nvl(pll.secondary_quantity_cancelled,0) = 0 and nvl(pll.quantity_cancelled,0) <> 0)