eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on PO_DISTRIBUTIONS

Line 168: * When v_po_header_id was null, we did not join po_distributions

164: AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id)
165: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
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: */

Line 170: * Changed the condition join po_distributions with po_line_locations

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,

Line 228: po_distributions pod,

224: NVL(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code,
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,

Line 295: po_distributions pod,

291: )
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,