APPS.POA_EDW_SUPPERF dependencies on RCV_SHIPMENT_LINES

Line 178: -- - rcv_shipment_lines - last_update_date

174: --
175: -- Returns the last transaction date for a particular shipment.
176: -- The dates considered are for:
177: -- - rcv_transactions - last_update_date for any transaction type
178: -- - rcv_shipment_lines - last_update_date
179: -- We should look at last_update_date instead of transaction_date for
180: -- rcv_transactions because the transaction_date can be in the past, but
181: -- the data would not be collected yet since it didn't exist then.
182: --

Line 210: -- Get max date from rcv_shipment_lines

206: v_max_rcv_trx_date := NULL;
207: END;
208:
209: --
210: -- Get max date from rcv_shipment_lines
211: --
212: BEGIN
213: SELECT MAX(last_update_date)
214: INTO v_max_shp_line_date

Line 215: FROM rcv_shipment_lines

211: --
212: BEGIN
213: SELECT MAX(last_update_date)
214: INTO v_max_shp_line_date
215: FROM rcv_shipment_lines
216: WHERE po_line_location_id = p_line_location_id;
217:
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN

Line 270: FROM rcv_shipment_lines rsl

266: '', -- to UOM code
267: rsl.unit_of_measure, -- from UOM name
268: p_shipment_uom)) -- to UOM name
269: INTO v_qty_shipped
270: FROM rcv_shipment_lines rsl
271: WHERE rsl.po_line_location_id = p_line_location_id;
272:
273: RETURN(NVL(v_qty_shipped, 0));
274: