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 170: * When v_po_header_id was null, we did not join po_distributions

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

Line 172: * Changed the condition join po_distributions with po_line_locations

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,

Line 232: po_distributions pod,

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

Line 299: po_distributions pod,

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