APPS.CSD_PROCESS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1364: select reservation_id from mtl_Serial_numbers

1360: l_ret_status varchar2(1);
1361: l_reservation_id number;
1362:
1363: cursor c_srl_reservation(p_srl_num varchar2, p_item_id number) is
1364: select reservation_id from mtl_Serial_numbers
1365: where serial_number = p_srl_num
1366: and inventory_item_Id = p_item_id;
1367:
1368: --bug#6071005

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

1855: End If;
1856: Else If Item is Non-Reservable
1857: If Item is serial Controlled then
1858: Get Lot_Number, Revision, Sub Inventory Information from
1859: Mtl_Serial_numbers for a given serial_number, item_id,organization_id
1860:
1861: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and
1862: Update Serial_Number, Quantity ( will be 1 for serial controlled
1863: items), lot_number, Revision and subinventory

Line 1954: from mtl_serial_numbers

1950:
1951: begin
1952: select Lot_Number, Revision, current_SubInventory_code
1953: into l_lot_number ,l_revision ,l_sub_inventory
1954: from mtl_serial_numbers
1955: where serial_number = l_shipped_serial_number
1956: AND inventory_item_id = i.inventory_item_id
1957: AND current_organization_id = i.organization_id;
1958: exception