[Home] [Help]
58: NVL(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code,
59: rsl.shipment_line_id,
60: rsl.item_id -- pl.item_id
61: FROM
62: po_line_locations pll,
63: po_lines pl,
64: po_headers ph,
65: RCV_SHIPMENT_LINES RSL,
66: RCV_SHIPMENT_HEADERS RSH
120: v_include_closed_po varchar2
121: )
122: IS
123: SELECT COUNT(*)
124: FROM po_line_locations pll,
125: po_lines pl,
126: po_headers ph,
127: RCV_SHIPMENT_LINES RSL,
128: RCV_SHIPMENT_HEADERS RSH
168:
169: /* Bug 3648871.
170: * When v_po_header_id was null, we did not join po_distributions
171: * table with other tables. Hence there was performance problem.
172: * Changed the condition join po_distributions with po_line_locations
173: * and po_lines in cursors asn_distributions and count_asn_distributions.
174: */
175: CURSOR asn_distributions(
176: v_shipment_header_id NUMBER,
229: rsl.shipment_line_id,
230: rsl.item_id
231: FROM
232: po_distributions pod,
233: po_line_locations pll,
234: po_lines pl,
235: po_headers ph,
236: RCV_SHIPMENT_LINES RSL,
237: RCV_SHIPMENT_HEADERS RSH
296: IS
297: SELECT COUNT(*)
298: FROM
299: po_distributions pod,
300: po_line_locations pll,
301: po_lines pl,
302: po_headers ph,
303: RCV_SHIPMENT_LINES RSL,
304: RCV_SHIPMENT_HEADERS RSH
685: /* Complex work.
686: * We have a separate procedure derive_matching_basis
687: * to get the matching basis now. This is because we
688: * are going to get the matching_basis from
689: * po_line_locations and hence moved it from
690: * derive_po_line_info.
691: */
692: PROCEDURE derive_matching_basis(
693: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,