DBA Data[Home] [Help]

APPS.RCV_QUANTITIES_S dependencies on RCV_SHIPMENT_LINES

Line 1171: FROM rcv_shipment_lines rsl

1167: x_item_id,
1168: x_shipment_uom,
1169: x_secondary_qty_shipped,
1170: x_secondary_qty_received
1171: FROM rcv_shipment_lines rsl
1172: WHERE rsl.shipment_line_id = p_shipment_line_id;
1173:
1174: x_progress := '010';
1175:

Line 1386: rcv_shipment_lines rsl

1382: INTO x_transaction_uom,
1383: x_item_id,
1384: x_primary_uom
1385: FROM rcv_transactions rt,
1386: rcv_shipment_lines rsl
1387: WHERE rsl.shipment_line_id = rt.shipment_line_id
1388: AND rt.transaction_id = p_transaction_id;
1389: -- bug 4873207
1390:

Line 1821: rcv_shipment_lines rsl

1817: rsl.item_id
1818: into x_parent_uom,
1819: x_item_id
1820: from rcv_transactions rt,
1821: rcv_shipment_lines rsl
1822: where rt.transaction_id = p_parent_id
1823: and rt.shipment_line_id = rsl.shipment_line_id;
1824:
1825: /*

Line 2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;

2087: l_subinventory rcv_transactions.subinventory%TYPE;
2088: l_locator_id rcv_transactions.locator_id%TYPE;
2089: l_po_header_id rcv_transactions.po_header_id%TYPE;
2090: l_po_line_id rcv_transactions.po_line_id%TYPE;
2091: l_item_revision rcv_shipment_lines.item_revision%TYPE;
2092: l_primary_rt_uom rcv_transactions.primary_unit_of_measure%TYPE;
2093:
2094: l_return_status VARCHAR2(1);
2095: l_msg_count NUMBER;

Line 2147: rcv_shipment_lines rsl

2143: l_po_line_id,
2144: l_item_revision,
2145: l_primary_rt_uom
2146: from rcv_transactions rt,
2147: rcv_shipment_lines rsl
2148: where rt.transaction_id = p_transaction_id
2149: and rt.shipment_line_id = rsl.shipment_line_id;
2150:
2151: x_progress := '010';

Line 3138: FROM rcv_shipment_lines rsl

3134: SELECT rsl.item_id,
3135: rsl.unit_of_measure
3136: INTO x_item_id,
3137: x_shipment_uom
3138: FROM rcv_shipment_lines rsl
3139: WHERE rsl.shipment_line_id = p_shipment_line_id;
3140:
3141: x_progress := '010';
3142: