DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on MTL_PARAMETERS

Line 133: FROM mtl_parameters

129: -- that value so that the same number will not be used again the next time
130: -- Generate_LPN is called for that org
131:
132: SELECT lpn_starting_number INTO l_lpn_start_num
133: FROM mtl_parameters
134: WHERE organization_id=p_org_id
135: FOR UPDATE;
136:
137: UPDATE MTL_PARAMETERS

Line 137: UPDATE MTL_PARAMETERS

133: FROM mtl_parameters
134: WHERE organization_id=p_org_id
135: FOR UPDATE;
136:
137: UPDATE MTL_PARAMETERS
138: SET lpn_starting_number = l_lpn_start_num+p_qty,
139: last_update_date = SYSDATE,
140: last_updated_by = FND_GLOBAL.USER_ID
141: WHERE organization_id = p_org_id;