APPS.RCV_ROI_TRANSACTION dependencies on PO_LINES

Line 63: po_lines pl,

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
67: WHERE

Line 125: po_lines pl,

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
129: WHERE

Line 173: * and po_lines in cursors asn_distributions and count_asn_distributions.

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,
177: v_shipment_line_id NUMBER,

Line 234: po_lines pl,

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
238: WHERE

Line 301: po_lines pl,

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
305: WHERE