APPS.PO_CHORD_WF1 dependencies on PO_DISTRIBUTIONS_ALL

Line 702: Modified the SQL statements to take header_id from PO_DISTRIBUTIONS_ALL

698: x_base_min_unit );
699:
700: /* Bug #: 1415223 draising
701: Forward fix of Bug # 1377624
702: Modified the SQL statements to take header_id from PO_DISTRIBUTIONS_ALL
703: table (for example : POLLA.po_header_id = x_po_header_id is changed to
704: PODA.po_header_id = x_po_header_id) to improve the performance
705: of sql statements.
706: */

Line 733: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL

729: * nvl(X_min_unit,1)/ nvl(X_base_min_unit,1)
730: )
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

Line 789: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL

785: (nvl(POD.quantity_ordered, 0) -
786: nvl(POD.quantity_cancelled, 0)) *
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