APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1274: FROM mtl_serial_numbers

1270:
1271: -- Patchset J change
1272: CURSOR msn_serial_csr (l_lpn_id NUMBER) IS
1273: SELECT serial_number
1274: FROM mtl_serial_numbers
1275: WHERE lpn_id = l_lpn_id;
1276:
1277: cursor serial_csr IS
1278: SELECT fm_serial_number

Line 1279: FROM mtl_serial_numbers_temp

1275: WHERE lpn_id = l_lpn_id;
1276:
1277: cursor serial_csr IS
1278: SELECT fm_serial_number
1279: FROM mtl_serial_numbers_temp
1280: WHERE transaction_temp_id=l_serial_temp_id ;
1281:
1282: CURSOR parent_lpn_cur ( p_innermost_lpn_id NUMBER ) IS
1283: SELECT lpn_id, license_plate_number, parent_lpn_id, organization_id, subinventory_code, locator_id,

Line 1818: UPDATE mtl_serial_numbers

1814: --because shipping relies on the fact the MSN.GROUP_MARK_ID
1815: --is not null, and inventory TM would have null it out
1816: --at this point
1817: BEGIN
1818: UPDATE mtl_serial_numbers
1819: SET group_mark_id = mtl_material_transactions_s.NEXTVAL
1820: WHERE serial_number = l_serial_number
1821: AND inventory_item_id = l_item_id
1822: AND current_organization_id = l_org_id;

Line 1880: UPDATE mtl_serial_numbers

1876: --because shipping relies on the fact the MSN.GROUP_MARK_ID
1877: --is not null, and inventory TM would have null it out
1878: --at this point
1879: BEGIN
1880: UPDATE mtl_serial_numbers
1881: SET group_mark_id = mtl_material_transactions_s.NEXTVAL
1882: WHERE serial_number = l_serial_number
1883: AND inventory_item_id = l_item_id
1884: AND current_organization_id = l_org_id;

Line 1948: UPDATE mtl_serial_numbers

1944: --because shipping relies on the fact the MSN.GROUP_MARK_ID
1945: --is not null, and inventory TM would have null it out
1946: --at this point
1947: BEGIN
1948: UPDATE mtl_serial_numbers
1949: SET group_mark_id = mtl_material_transactions_s.NEXTVAL
1950: WHERE serial_number = l_serial_number
1951: AND inventory_item_id = l_item_id
1952: AND current_organization_id = l_org_id;

Line 2008: UPDATE mtl_serial_numbers

2004: --because shipping relies on the fact the MSN.GROUP_MARK_ID
2005: --is not null, and inventory TM would have null it out
2006: --at this point
2007: BEGIN
2008: UPDATE mtl_serial_numbers
2009: SET group_mark_id = mtl_material_transactions_s.NEXTVAL
2010: WHERE serial_number = l_serial_number
2011: AND inventory_item_id = l_item_id
2012: AND current_organization_id = l_org_id;