DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 3240: FROM mtl_serial_numbers_interface

3236: IF (p_lot_control_code > 1 AND p_serial_control_code = 6) THEN
3237: BEGIN
3238: SELECT count(1)
3239: INTO l_msni_count
3240: FROM mtl_serial_numbers_interface
3241: WHERE product_transaction_id = p_transaction_temp_id
3242: AND product_code = 'RCV';
3243:
3244: IF (l_debug = 1) THEN

Line 5367: mtl_serial_numbers_interface msni

5363: rcv_transactions rt,
5364: rcv_serials_supply rss,
5365: rcv_shipment_lines rsl,
5366: rcv_shipment_headers rsh,
5367: mtl_serial_numbers_interface msni
5368: WHERE rs.item_id = p_item_id
5369: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5370: AND (p_revision is null or rs.item_revision = p_revision)
5371: AND rs.to_organization_id = p_organization_id