APPS.CSD_PROCESS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1401: select reservation_id from mtl_Serial_numbers

1397: l_ret_status varchar2(1);
1398: l_reservation_id number;
1399:
1400: cursor c_srl_reservation(p_srl_num varchar2, p_item_id number) is
1401: select reservation_id from mtl_Serial_numbers
1402: where serial_number = p_srl_num
1403: and inventory_item_Id = p_item_id;
1404:
1405: --bug#6071005

Line 1904: Mtl_Serial_numbers for a given serial_number, item_id,organization_id

1900: End If;
1901: Else If Item is Non-Reservable
1902: If Item is serial Controlled then
1903: Get Lot_Number, Revision, Sub Inventory Information from
1904: Mtl_Serial_numbers for a given serial_number, item_id,organization_id
1905:
1906: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and
1907: Update Serial_Number, Quantity ( will be 1 for serial controlled
1908: items), lot_number, Revision and subinventory

Line 1999: from mtl_serial_numbers

1995:
1996: begin
1997: select Lot_Number, Revision, current_SubInventory_code
1998: into l_lot_number ,l_revision ,l_sub_inventory
1999: from mtl_serial_numbers
2000: where serial_number = l_shipped_serial_number
2001: AND inventory_item_id = i.inventory_item_id
2002: AND current_organization_id = i.organization_id;
2003: exception