DBA Data[Home] [Help]

APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_SHIPMENT_LINES

Line 1026: DELETE FROM rcv_shipment_lines

1022: IF (g_asn_debug = 'Y') THEN
1023: asn_debug.put_line(sql%rowcount || ' RSH record deleted');
1024: END IF;
1025:
1026: DELETE FROM rcv_shipment_lines
1027: WHERE shipment_header_id = l_ship_header_id;
1028:
1029: IF (g_asn_debug = 'Y') THEN
1030: asn_debug.put_line(sql%rowcount || ' RSL record deleted');

Line 1394: rcv_shipment_lines rsl

1390: rt.deliver_to_location_id,
1391: rt.secondary_unit_of_measure,
1392: rt.secondary_uom_code
1393: FROM rcv_transactions rt,
1394: rcv_shipment_lines rsl
1395: WHERE transaction_id = p_transaction_id
1396: AND rt.shipment_line_id = rsl.shipment_line_id(+);
1397:
1398: CURSOR get_parent_row_from_rti(