APPS.PO_CHORD_WF1 dependencies on STANDARD

Line 735: AND POLL.shipment_type in ('STANDARD','PLANNED','BLANKET')

731: * nvl(X_base_min_unit,1)) , 0)
732: INTO x_po_total
733: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL
734: WHERE POD.po_header_id = x_po_header_id
735: AND POLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
736: AND POLL.line_location_id = POD.line_location_id;
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
739: x_po_total := 0;

Line 768: AND POLLA.shipment_type in ('STANDARD','PLANNED','BLANKET')

764: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
765: WHERE PODA.po_header_id = x_po_header_id
766: AND POLLA.latest_external_flag (+) = 'Y'
767: AND PODA.latest_external_flag (+) = 'Y'
768: AND POLLA.shipment_type in ('STANDARD','PLANNED','BLANKET')
769: AND POLLA.line_location_id = PODA.line_location_id;
770: EXCEPTION
771: WHEN NO_DATA_FOUND THEN
772: x_po_total_archive :=0;

Line 791: AND POLL.shipment_type in ('STANDARD','PLANNED','BLANKET')

787: nvl(POLL.price_override, 0)))
788: INTO x_po_total
789: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL
790: WHERE POD.po_header_id = x_po_header_id
791: AND POLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
792: AND POLL.line_location_id = POD.line_location_id;
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: x_po_total :=0;

Line 819: AND POLLA.shipment_type in ('STANDARD','PLANNED','BLANKET')

815: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
816: WHERE PODA.po_header_id = x_po_header_id
817: AND POLLA.latest_external_flag (+) = 'Y'
818: AND PODA.latest_external_flag (+) = 'Y'
819: AND POLLA.shipment_type in ('STANDARD','PLANNED','BLANKET')
820: AND POLLA.line_location_id = PODA.line_location_id
821: AND PODA.po_header_id = POLLA.po_header_id;
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN