[Home] [Help]
56: NVL(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code,
57: rsl.shipment_line_id,
58: rsl.item_id -- pl.item_id
59: FROM
60: po_line_locations pll,
61: po_lines pl,
62: po_headers ph,
63: RCV_SHIPMENT_LINES RSL,
64: RCV_SHIPMENT_HEADERS RSH
118: v_include_closed_po varchar2
119: )
120: IS
121: SELECT COUNT(*)
122: FROM po_line_locations pll,
123: po_lines pl,
124: po_headers ph,
125: RCV_SHIPMENT_LINES RSL,
126: RCV_SHIPMENT_HEADERS RSH
166:
167: /* Bug 3648871.
168: * When v_po_header_id was null, we did not join po_distributions
169: * table with other tables. Hence there was performance problem.
170: * Changed the condition join po_distributions with po_line_locations
171: * and po_lines in cursors asn_distributions and count_asn_distributions.
172: */
173: CURSOR asn_distributions(
174: v_shipment_header_id NUMBER,
225: rsl.shipment_line_id,
226: rsl.item_id
227: FROM
228: po_distributions pod,
229: po_line_locations pll,
230: po_lines pl,
231: po_headers ph,
232: RCV_SHIPMENT_LINES RSL,
233: RCV_SHIPMENT_HEADERS RSH
292: IS
293: SELECT COUNT(*)
294: FROM
295: po_distributions pod,
296: po_line_locations pll,
297: po_lines pl,
298: po_headers ph,
299: RCV_SHIPMENT_LINES RSL,
300: RCV_SHIPMENT_HEADERS RSH
681: /* Complex work.
682: * We have a separate procedure derive_matching_basis
683: * to get the matching basis now. This is because we
684: * are going to get the matching_basis from
685: * po_line_locations and hence moved it from
686: * derive_po_line_info.
687: */
688: PROCEDURE derive_matching_basis(
689: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,