DBA Data[Home] [Help]

APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_SHIPMENT_LINES

Line 877: DELETE FROM rcv_shipment_lines

873: IF (g_asn_debug = 'Y') THEN
874: asn_debug.put_line(sql%rowcount || ' RSH record deleted');
875: END IF;
876:
877: DELETE FROM rcv_shipment_lines
878: WHERE shipment_header_id = l_ship_header_id;
879:
880: IF (g_asn_debug = 'Y') THEN
881: asn_debug.put_line(sql%rowcount || ' RSL record deleted');

Line 1222: rcv_shipment_lines rsl

1218: rt.deliver_to_location_id,
1219: rt.secondary_unit_of_measure,
1220: rt.secondary_uom_code
1221: FROM rcv_transactions rt,
1222: rcv_shipment_lines rsl
1223: WHERE transaction_id = p_transaction_id
1224: AND rt.shipment_line_id = rsl.shipment_line_id(+);
1225:
1226: CURSOR get_parent_row_from_rti(