APPS.RCV_QUANTITIES_S dependencies on RCV_SHIPMENT_LINES

Line 1383: FROM rcv_shipment_lines rsl

1379: x_item_id,
1380: x_shipment_uom,
1381: x_secondary_qty_shipped,
1382: x_secondary_qty_received
1383: FROM rcv_shipment_lines rsl
1384: WHERE rsl.shipment_line_id = p_shipment_line_id;
1385:
1386: x_progress := '010';
1387:

Line 1600: rcv_shipment_lines rsl

1596: INTO x_transaction_uom,
1597: x_item_id,
1598: x_primary_uom
1599: FROM rcv_transactions rt,
1600: rcv_shipment_lines rsl
1601: WHERE rsl.shipment_line_id = rt.shipment_line_id
1602: AND rt.transaction_id = p_transaction_id;
1603: -- bug 4873207
1604:

Line 2067: rcv_shipment_lines rsl

2063: rsl.item_id
2064: into x_parent_uom,
2065: x_item_id
2066: from rcv_transactions rt,
2067: rcv_shipment_lines rsl
2068: where rt.transaction_id = p_parent_id
2069: and rt.shipment_line_id = rsl.shipment_line_id;
2070:
2071: /*

Line 2536: l_item_revision rcv_shipment_lines.item_revision%TYPE;

2532: l_subinventory rcv_transactions.subinventory%TYPE;
2533: l_locator_id rcv_transactions.locator_id%TYPE;
2534: l_po_header_id rcv_transactions.po_header_id%TYPE;
2535: l_po_line_id rcv_transactions.po_line_id%TYPE;
2536: l_item_revision rcv_shipment_lines.item_revision%TYPE;
2537: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;
2538:
2539: l_return_status VARCHAR2(1);
2540: l_msg_count NUMBER;

Line 2600: rcv_shipment_lines rsl

2596: l_item_revision,
2597: l_lpn_id, /*added in bug 13892629 */
2598: l_primary_rt_uom
2599: from rcv_transactions rt,
2600: rcv_shipment_lines rsl
2601: where rt.transaction_id = p_transaction_id
2602: and rt.shipment_line_id = rsl.shipment_line_id;
2603:
2604: x_progress := '010';

Line 4022: FROM rcv_shipment_lines rsl

4018: SELECT rsl.item_id,
4019: rsl.unit_of_measure
4020: INTO x_item_id,
4021: x_shipment_uom
4022: FROM rcv_shipment_lines rsl
4023: WHERE rsl.shipment_line_id = p_shipment_line_id;
4024:
4025: x_progress := '010';
4026: