APPS.PO_RELEASES_SV4 dependencies on STANDARD

Line 353: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED');

349: pll.po_line_id = X_po_release_id_record.po_line_id
350: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
351: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
352: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
353: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED');
354:
355: IF v_count = 1 THEN
356:
357: select pll.po_release_id, pll.line_location_id, pll.shipment_num

Line 367: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED');

363: pll.po_line_id = X_po_release_id_record.po_line_id
364: and NVL(pll.APPROVED_FLAG,'N') = 'Y' -- bug 610238 should include the same clause as above
365: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
366: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
367: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED');
368:
369: ELSE
370:
371: x_po_release_id_record.po_line_location_id := NULL;