DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1819: SET group_mark_id = mtl_material_transactions_s.NEXTVAL

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;
1823: EXCEPTION

Line 1881: SET group_mark_id = mtl_material_transactions_s.NEXTVAL

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;
1885: EXCEPTION

Line 1949: SET group_mark_id = mtl_material_transactions_s.NEXTVAL

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;
1953: EXCEPTION

Line 2009: SET group_mark_id = mtl_material_transactions_s.NEXTVAL

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;
2013: EXCEPTION